Re: $$Excel-Macros$$ Comvert Excel/CSV to XML

2011-12-07 Thread Aindril De
Hi Rajan, Thanks for your prompt response. After testing this code. I had the following output: Files created with .xml extension, according to the number of records. These files were in the XML format, however the Tags were not as per the column heads. following is a sample output: - http:

Re: $$Excel-Macros$$ Comvert Excel/CSV to XML

2011-12-06 Thread rajan verma
Hi Please try this : Sub MakeXML() Dim strPath As String Dim rngUsed As Range Dim rngRow As Range Dim wbknew As Workbook With Application.FileDialog(msoFileDialogFolderPicker) .Title = "please Choose Folder to Save XML File" .Show strPat

$$Excel-Macros$$ Comvert Excel/CSV to XML

2011-12-05 Thread Aindril De
Hi All, I have a dataset in Excel. I have to do the following: 1) Convert the dataset to XML Format 2) Create a different XML File for each row. Any help would be really appreciated. Cheers -- Andy -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread ti