Macro to import an excel worksheet into a specific worksheet.

Hi,

Im needing help on macro which imports a worksheet(s) into the open workbook's specific worksheet(s).

We have a shared drive with the files in one folder I want to import from. When I run the macro i want them to drop into specific worksheet(s), i.e refreshing the workbook
So far i have this:

Sub GetFile()
' This macro will import a file into this workbook

Please Login or Register  to view this content.

But it just creates new worksheet with the name in "D4" not copy into Tabname "D4".

Any help would be really appreciated, im just starting out on macro's.