VBA: Open file in new tab of existing workbook

[Brondius]

Looking to open a file as a new tab of an existing workbook. I'm going to loop it through all the files in a folder, but the part I'm having trouble with is getting the file to open in an existing workbook. These are HTML files that open fine in Excel, I just can't figure out how to get them to open in an existing workbook.

Any help would be greatly appreciated.

 

[Norie]

How are you opening them manually?

 

[Brondius]

I just ctrl + o and select the file. It opens the file in a new workbook. Can't seem to get them to open in the same workbook, though.