MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Moving workbooks in code to next workbook

Posted by Dan on July 21, 2000 6:39 AM

Is there a code that would take the place of the workbook name. (as seen below):

ActiveSheet.Copy before:=Workbooks("###.xls").Sheets(2)

i.e. I want the selection to move to the next workbook. (the problem is that I don't always know the name of the book - hence I can't put the name in).

Can anyone help?


Posted by Ada on July 21, 0100 6:52 AM

Try this to see if it does what you want :-

ActiveSheet.Copy before:=Workbooks(2).Sheets(2)