|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Read multiple xml files in excel - Column names and Tag - Column alignment
Hello All,
I am using the below code to read multiple xml files into a single excel worksheet. I am looking to do below 2 amends:
My Code: Do While xFile <> "" Set xmlWb = Workbooks.OpenXML(folderPath & "\" & xFile) xmlWb.Sheets(1).UsedRange.Copy xlSWb.Sheets(2).Cells(xCount, 1) Application.DisplayAlerts = False xmlWb.Saved = True xmlWb.Close False Application.DisplayAlerts = True xCount = xlSWb.Sheets(2).UsedRange.Rows.Count + 1 xFile = Dir() Loop |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Embedded Excel in Powerpoint - custom animation, display column by column | andytheanimal | PowerPoint | 2 | 01-20-2015 06:30 AM |
Multiple Row Headings and Last Column Alignment | Pecan | Word Tables | 6 | 09-13-2013 12:20 PM |
matching names in column A with names in column C | bob999999 | Excel | 1 | 04-28-2013 11:21 AM |
Automatically enter date into a column and make that column read only | Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
Unwanted column alignment | SquareAce | Word Tables | 4 | 11-08-2011 01:28 AM |