Windows Vista Forums

Reading Excel XML spreadsheet via VBScript using MSXML.DOMDocument

  1. #1


    James Whitlow Guest

    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

  2. #2


    A possible solution Guest

    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:

    > 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

  3. #3


    James Whitlow Guest

    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

    > 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

  4. #4


    Paul Randall Guest

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


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

    > 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

Reading Excel XML spreadsheet via VBScript using MSXML.DOMDocument

Similar Threads
Thread Forum
Creating Lables from excel spreadsheet in MS Word
I followed instructions and imported my worksheet data (3 addresses) into labels, however, one label is blank & remaining labels have "Next...
Vista mail
Set homeDrive and homeDirectory from excel spreadsheet
I have a set of scripts that I've got worked out to create profile and home folders then set the Terminal Server Profile path and home drive and...
VB Script
create Excel spreadsheet without loading Excel
Greetings, I have a script which uses CreateObject("Excel.Application") to create a spreadsheet. This works fine on my machine since I have Excel...
VB Script
Excel Spreadsheet Problem
I am trying to count text in specific cells, not in a range. How can I accomplish this? Specifically, I am trying to count the occurences of "UL"...
Software
Excel Spreadsheet Help
Hey, I have a weekly Poker group and I made a spreadsheet for it to keep track of all the satistics. Iv managed to make a worksheet for each...
Software
Adding headers to an excel spreadsheet
Guys, I cant seem to be able to open up an excel spreadsheet using powershell. I get an error "Exception calling "open" with "1" arguement(s):...
PowerShell
EXCEL spreadsheet running slow
My unit is Acer 5570 intel core solo 1.86GHz, DDR2 1536MB, Window Home VISTA Basic. Office 2003, when i am plugged / connected on LAN my EXCEL...
Vista performance & maintenance