Open file in existing excel tab

[pokerwoody]

I have a tab titled "Data" I would like to have a macro that would open a folder where i can select file to open in this tab. For example, run macro it would open C:\files and there i can select the file i would like to open within the "Data" tab.

Any help appreciated.

 

[ParamRay]

And if the selected file contains more than one sheet?...

 

[pokerwoody]

yes, it would have multiple files, but will just want to choose 1. Would want to import into tab. This is a .dat file. Currently whne i opein it opens in a new workbook.

thanks..