Error 1004 - Copy Sheet

[artiszta]

Hi folks,

I need your help, as I'm getting now a bit frustrated, as I do not recognize the issue.... Actually the code works fine in 90% of the cases, but for whatever reason for some users from one minute to another not... Means they used it without any problems, and then they getting an error.
As I know to copy a sheet it must be existing and visible... It is according to the code.
The Thisworkbook is also the active workbook in at foreground, due that the fact that the userform in this file starts the proccess.
Also the network drive is available according our network admins.
So what else can it be?


Thx you all!
Cheers
Artiszta

Please Login or Register  to view this content.

[Norie]

Where do you get the error and what's the error message?

[artiszta]

Honestly I don't know as while debugging we don't get any error.

As the errormassage is: '#1004 copy method of worksheet class failed', I guess it's in the line:

Please Login or Register  to view this content.

Thx!

[artiszta]

Actually the Problem still occurs but I was going another way. Instead of debug this error I was going to the solution of in case of an error a new Workbook shall be created (not copied) and if that also fails, then use Notepad to create the csv file. And finally if that also not succeed then make save the macro file on C:\ for further analysis.

I found this:http://support.microsoft.com/kb/210684. And however it's not the same issue but means that sometimes coping sheets won't work.