Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Importing XML files
0 views
Skip to first unread message
Microsoft News
May 29, 2009, 11:08:35 PM5/29/09
to
I am geting numerous emails from a mainframe providing status on data
transfers. The output is an XML file. I save each attachment to a directory
on my hard drive. Right now I have to import them one at a time into Excel
(Data | From Other Sources | From XML Data Import | FileName).
transfers. The output is an XML file. I save each attachment to a directory
on my hard drive. Right now I have to import them one at a time into Excel
(Data | From Other Sources | From XML Data Import | FileName).
Is there a way to just import all the files en masse into Excel at one time?
---Mike
Boris Lehečka
Jul 17, 2009, 10:56:16 AM7/17/09
to
I think using Macro solves your problem. Iterate over all files in
directory and import each file into Excel.
directory and import each file into Excel.
Boris Lehačka
Dne 30.5.2009 5:08, Microsoft News napsal(a):
0 new messages