Copy a sheet from a closed workbook?

[Azban65]

Hello,

How can I copy from a closed workbook into an open workbook?
I tried with the Getdata command but it's for range, I like to copy the whole sheet to keep the hyperlink, format etc....

Thanks

Azban

 

[SkipVought]

Hi,

You must have the workbook opened to do what you described.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Azban65]

aaaaaaaaaaarrrrgggg

sure??? Anyway, It's working like that, but it's just long...

Thanks