Converting an Excel sheet to an XML file.
 

Hi

I have an excel sheet by name "sheet1" and it contains some data in it . I
want to convert this excel sheet into an XML file programmatically . Please
consider this as urgent

Regards,
Satyam Reddy.

Converting an Excel sheet to an XML file.
 

Do you have a DTD/Schema ?

Tim

"Satyam Reddy" wrote in message
...
Hi

I have an excel sheet by name "sheet1" and it contains some data in it . I
want to convert this excel sheet into an XML file programmatically .
Please
consider this as urgent

Regards,
Satyam Reddy.

Converting an Excel sheet to an XML file.
 

HI williams.

I do not have any specific DTD/Schema. please take into consideration any
excel sheet which has column headers some thing like this "empno","ename",
"salary", "hiredate" and the data is present in around 5 rows for the above
columns. Taking this aspect into consideration please guide me to convert
the excel sheet into XML file using VBA (Visual Basic For Applications). THe
XML file must be in the form of notes as of the general XML file format.


Regards,
Satyam Reddy


"Tim Williams" wrote:

Do you have a DTD/Schema ?

Tim

"Satyam Reddy" wrote in message
...
Hi

I have an excel sheet by name "sheet1" and it contains some data in it . I
want to convert this excel sheet into an XML file programmatically .
Please
consider this as urgent

Regards,
Satyam Reddy.

Converting an Excel sheet to an XML file.
 

An XML file is just text, so Google for how to write a text file using
VBA.
Then just format the text in the file as XML.

Since you don't have a required format, I can't suggest a layout...

Tim


On Apr 16, 6:27*am, Satyam Reddy
wrote:
HI williams.

I do not have any specific DTD/Schema. please take into consideration any
excel sheet which has column headers some thing like this "empno","ename",
"salary", "hiredate" and the data is present in around 5 rows for the above
columns. Taking this aspect into consideration *please guide me to convert
the excel sheet into XML file using VBA (Visual Basic For Applications). THe
XML file must be in the form of notes as of the general XML file format.

Regards,
Satyam Reddy



"Tim Williams" wrote:
Do you have a DTD/Schema ?

Tim

"Satyam Reddy" wrote in message
...
Hi

I have an excel sheet by name "sheet1" and it contains some data in it . I
want to convert this excel sheet into an XML file *programmatically ..
Please
consider this as urgent

Regards,
Satyam Reddy.- Hide quoted text -

- Show quoted text -

Converting an Excel sheet to an XML file.
 

"THe XML file must be in the form of notes as of the general XML file
format."

Not sure what you mean by this. Can you post an example of what you want
the final XML output to look like ?

Tim


"Satyam Reddy" wrote in message
...
HI williams.

I do not have any specific DTD/Schema. please take into consideration any
excel sheet which has column headers some thing like this "empno","ename",
"salary", "hiredate" and the data is present in around 5 rows for the
above
columns. Taking this aspect into consideration please guide me to convert
the excel sheet into XML file using VBA (Visual Basic For Applications).
THe
XML file must be in the form of notes as of the general XML file format.


Regards,
Satyam Reddy


"Tim Williams" wrote:

Do you have a DTD/Schema ?

Tim

"Satyam Reddy" wrote in message
...
Hi

I have an excel sheet by name "sheet1" and it contains some data in it
. I
want to convert this excel sheet into an XML file programmatically .
Please
consider this as urgent

Regards,
Satyam Reddy.