Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.scripting.vbscript,microsoft.public.excel.programming
|
|||
|
|||
Reading Excel XML spreadsheet via VBScript using MSXML.DOMDocument
I am looking for some resource, samples or guidance in reading data from
Excel spreadsheets saved in XML format using VBScript, but using the 'MSXML.DOMDocument' object instead of the 'Excel.Application' object. My goal is to do my updating to the table in a nicely formatted Excel document instead of a unformatted CSV file, but have the script still work on computers that do not have Excel installed. I have quite limited experience with working with XML documents, so if someone has some simple examples they can post or link to that I could analyze and learn from, it would be greatly appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programmatically reading the excel sheet name--vbscript | Excel Programming | |||
Problem reading value from Excel spreadsheet | Excel Programming | |||
How to test if an Excel spreadsheet exists in VBScript? | Excel Programming | |||
Opening excel spreadsheet from within a VBscript | Excel Programming | |||
VBScript Automation of Excel Spreadsheet Sorting & Filtering | Excel Programming |