Worksheet Being Copied To Wrong Workbook

[Jenn68]

Please Login or Register  to view this content.

This code is within active workbook 1, worksheet 1. I wish to make a copy of ws_stsked in hidden workbook 2 (aka wb_sschedule) into that same workbook and call it "staff_schedule_copy".

This code is placing the copy into workbook 1, not workbook 2.

How do I copy into the proper workbook 2?

[mjr veverka]

Try:

Please Login or Register  to view this content.

, but what do you mean by the term "hidden workbook 2" ?

[Jenn68]

Hi porucha vevrku, thank you for your reply.

The only line I felt I needed to change was to this ...
[/code].Copy After:=wb_sschedule.Worksheets(wb_sschedule.Sheets.Count)[/code]
which now results in an error ... "Method of object '_Worksheet' failed."

what do you mean by the term "hidden workbook 2" ?

meaning it is open, but not visible.

wb_sschedule is recognized, as is ws_stsked is also recognized.

[mjr veverka]

... but the workbook itself is invisible for certain operations, especially those with the prefix "active" ...

Please Login or Register  to view this content.

[Jenn68]

Perfect. I have to expose the workbook (ie visible = true) before I can copy to it.
Thank you!