Automation of XML
-
Dear All,, Can U Help me to Generate the XML document from Excel Worksheet by Using Macro and VBA facility...Excel 2003 professional Edition have an option like XML in Data Menu..I have Excel 2003 Standard Edition... Please Help me to get the Solution Thanks n Regards, Ramya.R
-
Dear All,, Can U Help me to Generate the XML document from Excel Worksheet by Using Macro and VBA facility...Excel 2003 professional Edition have an option like XML in Data Menu..I have Excel 2003 Standard Edition... Please Help me to get the Solution Thanks n Regards, Ramya.R
Sub SaveAsXML() ActiveWorkbook.SaveAs Filename:= "C:\Book3.xml", FileFormat:= _ xlXMLSpreadsheet, ReadOnlyRecommended:=False, CreateBackup:=False End Sub If you are trying to save the workbook that contains the macro, you will get a message about not being able to save the vbproject, but I assume the Macro will not be in the workbook you are saving as XML?
-
Sub SaveAsXML() ActiveWorkbook.SaveAs Filename:= "C:\Book3.xml", FileFormat:= _ xlXMLSpreadsheet, ReadOnlyRecommended:=False, CreateBackup:=False End Sub If you are trying to save the workbook that contains the macro, you will get a message about not being able to save the vbproject, but I assume the Macro will not be in the workbook you are saving as XML?
Dear Richard:rose: Thanks For your Reply. Actually that Worksheet is in .xls format. I need to Write a Macro that Take the Column value from the Excel Sheet and Generate the Xml File From the particular field...:(( Thanks n Regards, Ramya.R -- modified at 6:36 Thursday 23rd February, 2006
-
Dear Richard:rose: Thanks For your Reply. Actually that Worksheet is in .xls format. I need to Write a Macro that Take the Column value from the Excel Sheet and Generate the Xml File From the particular field...:(( Thanks n Regards, Ramya.R -- modified at 6:36 Thursday 23rd February, 2006
Hi What do you want to do with the XML file? You can write 'text' to a file, in the following format: You can test this by taking the above, pasting it into notepad, save it. Then change the extension from txt to xml. Then try opening it with the application that requires the file. You'd have to look at the VBA help to see how to do the FileIO though. (Can help you with VB.Net code only, not VBA ->> Sorry)
-
Hi What do you want to do with the XML file? You can write 'text' to a file, in the following format: You can test this by taking the above, pasting it into notepad, save it. Then change the extension from txt to xml. Then try opening it with the application that requires the file. You'd have to look at the VBA help to see how to do the FileIO though. (Can help you with VB.Net code only, not VBA ->> Sorry)