Using the GetOpenFileName method to import sheets after activesheet

Hi,

I'm trying to use the GetOpenFileName method to import sheets.

Please Login or Register  to view this content.

I'm getting two errors:
1)

Please Login or Register  to view this content.

I Get a Type MisMatch Error whenever I select a file
2)

Please Login or Register  to view this content.

Also get a Type MisMatch Error...

Any ideas ?

Thanks!
amphi

Try this.

Please Login or Register  to view this content.

Thanks apo & Norie. Now I'm getting a "To hide, delete, or move the selected sheet(s), you must first insert a new sheet or unhide a sheet that is already hidden." The first sheet on the file I'm importing exists and is visible...

Edit: Switched the Move After to Copy After (the file I was importing from only had one worksheet which couldn't be moved) . Solved !