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:
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
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