Making XML document using Excel macro

[Shishir01]

Hi,
I want to make a xml document using Excel macros.

The code should read the cell contents of the excel worksheet and generate tags accordingly.

[ADezii]

You can try code similar to the following:

Dim wrkBk As Workbook
Dim fName As String

'Substitute your own Range for A1:G19
Range("A1:G19").Select

Do
  fName = Application.GetSaveAsFilename
Loop Until fName <> ""

ActiveWorkbook.SaveAs Filename:=fName, FileFormat:= _
               xlXMLSpreadsheet, ReadOnlyRecommended:=False, CreateBackup:=False