Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining 2 HTML files into a Single Workbook
I've got two HTML files containing tables - output of Business Objects -
and I need to put them into the same workbook - on different worksheets - will all the formatting that they currently have, any ideas ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining 2 HTML files into a Single Workbook
Greg
You should be able to open them as their own separate workbooks, then copy one sheet over to the other. Sub TwoHTML() Dim wb1 As Workbook Dim wb2 As Workbook Set wb1 = Workbooks.Open("C:\Dick\Table 1.html") Set wb2 = Workbooks.Open("C:\Dick\Table2.htm") Dim sh As Worksheet wb1.Sheets(1).Copy wb2.Sheets(1) wb1.Close False End Sub -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Greg Griffiths" wrote in message ... I've got two HTML files containing tables - output of Business Objects - and I need to put them into the same workbook - on different worksheets - will all the formatting that they currently have, any ideas ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining files to one workbook | Excel Discussion (Misc queries) | |||
merging single worksheet files into a single workbook | Excel Discussion (Misc queries) | |||
Pasting HTML into a single cell | Excel Discussion (Misc queries) | |||
Save single sheet from XLS file as HTML | Excel Discussion (Misc queries) | |||
Importing multiple text files into single workbook | Excel Programming |