Open file into sheet in currently open workbook

[stevecar144]

Hello all,
I'm a newbie here so if this is posted in the wrong place apologies...

I have an Excel 2007 workbook with several worksheets. To update the content I want to open an html file into a new blank worksheet in the currently open workbook. So far every thing I have tired results in a new workbook being opened with the name of the data file that I am opening.

Is there a way to open a file into an existing worksheet please???

TIA.

Steve C

[JLGWhiz]

Assuming that the last sheet in your workbook is blank, you can use a Workbook_Open macro.

Please Login or Register  to view this content.

Goes in the ThisWorkbook code module. If you already have a Workbook_Open macro, just add the 'Select' line to that macro, since you cannot have two of the same event macros in a module.