Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You can save your workbook in XML format but you don't get much control
of how the XML looks. This will get you started, it writes : <xml <datasomedata</data </xml to a file named my.xml Open "C:\my.xml" For Output As #1 Print #1, "<xml"+ Chr(10) Print #1, "<datasomedata</data+ Chr(10) Print #1, "</xml" + Chr(10) Close #1 I haven't done reading in a while, but last I checked you had to add MSXML 4.0 and that added an XML library to your references that provides all the normal DOM subs and functions. Excel will read XML natively, you can access the worksheet and cells it creates. Try that first. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
read only file-need to write | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
Read and Write Excel file | Excel Programming | |||
Read variables from external file | Excel Programming |