Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - Reading Excel XML spreadsheet via VBScript using MSXML.DOMDocument

Reply
 
Old 06-08-2009   #1 (permalink)
James Whitlow


 
 

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.




My System SpecsSystem Spec
Old 06-08-2009   #2 (permalink)
A possible solution


 
 

RE: Reading Excel XML spreadsheet via VBScript using MSXML.DOMDocument

Sorry I can't provide you any more direct and immediate solution, but I
though you might find this book helpful:

http://books.google.com/books?id=gMjVl2r6XzEC

Best wishes,
Rolf

"James Whitlow" wrote:
Quote:

> 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.
>
>
>
>
My System SpecsSystem Spec
Old 06-08-2009   #3 (permalink)
James Whitlow


 
 

Re: Reading Excel XML spreadsheet via VBScript using MSXML.DOMDocument

"A possible solution" <Apossiblesolution@xxxxxx> wrote in
message news:8D61EF07-B002-4ECC-B36F-D039D3C4F08D@xxxxxx
Quote:

> Sorry I can't provide you any more direct and immediate solution, but I
> though you might find this book helpful:
>
> http://books.google.com/books?id=gMjVl2r6XzEC
Thanks for the reference, Rolf. I am going to keep searching and holind out
hope that a sample will be posted. If not, I might either fallback on the
book or just start experimenting myself.

I have incorporated simple XML tables into some of my scripts, but I am
still an XML novice.


My System SpecsSystem Spec
Old 06-09-2009   #4 (permalink)
Paul Randall


 
 

Re: Reading Excel XML spreadsheet via VBScript using MSXML.DOMDocument


"James Whitlow" <jwhitlow.60372693@xxxxxx> wrote in message
news:%23eUaPBF6JHA.1420@xxxxxx
Quote:

> 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.
I know almost nothing about XML documents or how that document might include
the Excel formatting. I would suggest groups.google.com; I would suggest
using it to search for msxml.domdocument in the microsoft.public ... xml
groups. One hit I found was
http://groups.google.com/g/85b7fefb/...5fe81604c15951
which might have helpful info.
There are a bunch of English language microsoft.public ... xml groups,
including:
microsoft.public.data.xmlanalysis
microsoft.public.dotnet.xml
microsoft.public.office.xml
microsoft.public.sqlserver.xml
microsoft.public.xml

On the main groups.google.com web page is a place to search for a group.
Enter something like the two words: microsoft xml to help you decide which
groups might be good candidates for crossposting your request. This returns
a nice list of group candidates, as well as some info on how frequently the
groups are used.

Use the search at msdn.microsoft.com, for something like: msxml.domdocument
reference, to find info that will be helpful in scripting the
msxml.domdocument object model.

-Paul Randall


My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Set homeDrive and homeDirectory from excel spreadsheet VB Script
create Excel spreadsheet without loading Excel VB Script
Excel Spreadsheet Problem Microsoft Office
Excel Spreadsheet Help Software
EXCEL spreadsheet running slow Vista performance & maintenance


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46