ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing XML files into individual worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/84843-importing-xml-files-into-individual-worksheets.html)

PabloB

Importing XML files into individual worksheets
 

I'm using a web page to create several xml files. Each file uses the
same schema only the content of the file changes. I need to be able to
import all the files into one workbook and create individual sheets for
each file. So if I have 3 files called x.xml y.xml and z.xml then I
would need 3 sheets labeled x, y, and z. Any suggestions:confused: ?
Thanks.


--
PabloB
------------------------------------------------------------------------
PabloB's Profile: http://www.excelforum.com/member.php...o&userid=31239
View this thread: http://www.excelforum.com/showthread...hreadid=535617



All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com