Move tab from Workbook1 to Workbook2 using Macro VBA

**nachousa** · 07-08-2010, 08:46 AM

I have workbook1 open and I want to move one of its tabs to workbook2.
Workbook1 and workbook2 may vary. I used the "Application.GetOpenFilename" to open workbook1 and now I have
to use it to open workbook2.
This is what I have so far.

Please Login or Register  to view this content.

This is kinda confusing because I dont want to use any specific names since both WB1 and WB2 may vary,
Do you follow?

Any Ideas??

**nachousa** · 07-08-2010, 09:29 AM

Is there a function to activate/operate in the Most Recent Opened Workbook?

**royUK** · 07-08-2010, 09:31 AM

Try

Please Login or Register  to view this content.

**nachousa** · 07-08-2010, 09:58 AM

Hey thanks for that.
It still didn't work though, I got an error at

Please Login or Register  to view this content.

The Error is Script out of Range. I think it is still looking for the DATA tab in the recently open workbook.
thanks for you help.

**nachousa** · 07-08-2010, 10:26 AM

Any Ideas why is not working?
I tried editing some but I cannot get it to work.
Hope you can help.
Thanks

**nachousa** · 07-08-2010, 11:58 AM

This is my Goal:
Click Button. WB2 will open, data tab from WB1 will move to WB2. that is all. But it is hard since the two Workbooks vary.
Just the fact that I cant use any specific workbook names makes it a lot harder.

Hope you can help.

Thanks