Reference Sheet In Other Workbook - Copy To

[Logit]

.
Yesterday the following macro worked fine (literally). I haven't done anything to the code or the workbook since.

No runs, no drips, no errors.


Today, workbook #1 that is doing the pasting to the other workbook, won't run the macro. It stops execution on this line :

Please Login or Register  to view this content.

No error code ... just a message that says 'Execution stopped.'

So I did more research and simply tried changing the variables ... no luck. (see different variables listed below)

I deleted the sheet in WB#1, saved the workbook, re-opened and re-created the worksheet with the macro pasted fresh.
Same error message.


The sheet names are accurate. The workbook names are accurate. Soooooooo .... why won't it run today ?

I swear Excel is of the female gender. I know ... I know ... that was politically incorrect but I'm angry and venting !


ORIGINAL REFERENCE:

Please Login or Register  to view this content.

SECOND REFERENCE:

Please Login or Register  to view this content.

COMPLETE MACRO:

Please Login or Register  to view this content.

Worksheet("Database") is hidden in the other workbook. This wasn't an issue previously. ????

[TMS]

I suspect it's because of this line:

Please Login or Register  to view this content.

You can't Activate a Hidden worksheet.

[Fluff13]

What happens if you remove this line

Please Login or Register  to view this content.

Also, does the workbook actually open?

[Logit]

.
The workbook does open.

I've disabled the ON ERROR statement and the Worksheets("Database").Activate

I'm still receiving the Code Execution Has Been Interrupted. No error message.

Workbook attached ....

[Fluff13]

It works for me, so not sure what to advise.

[Logit]

.
Grrrrrrrrrr .....

[Logit]

.
Ok ... I relented and uninstalled Office 2007 then re-installed it.

Everything works fine ... again.


The issue is that give things a week or so and it will occur again, without notice. That is frustrating.
I shouldn't have to re-install software to get it to work correctly.


I read a few nights ago where someone was having issues with the Iobit software (System Care, Uninstall, Anti-Virus, etc). That software was causing issues with
his system so he uninstalled it. No more issues.

Has anyone else had issues with Iobit ?

I have uninstalled it here as a test.