Re: code to convert an excel sheet into an XML file
:) Hi
i have a requirement like this . I have an excel sheet which contains data in 5 rows and 5 columns and the data in the first row is considered as headings of the columns. I need to convert this excel sheet into an xml file programatically using VBA. so please any one help me in this regard as i need the code very urgently. The xml file must be in the form of nodes as of normal xml files
Regards,
satyam reddy
Re: code to convert an excel sheet into an XML file
i believe in later versions of excel you can saveAs to create an xml file