Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Violet Nelson on Sep 17 In MS Office Category.

Next Workbook or Previous Workbook

Question Answered By: Vid Fischer on Sep 17

You could use workbooks("name.xls").activate. with the name of the original
workbook instead of name.

If the name might change you could capture it before opening the other one
with

pwkbk=ActiveWorkbook.Name

then after the paste use

workbooks(pwkbk).activate

This Question has 4 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Next Workbook or Previous Workbook Or get search suggestion and latest updates.

Related Topics:

Counting the rows If the next row value is same as the previous row
Making a Workbook as an Active Workbook without opening it
Run Macor in a closed workbook and refer to the closed workbook
Prob running workbook activate code when workbook is opened by anot
Change Workbook's Name
For Each (If Next) Next
Cell validation based on the contents of previous cell
Return to exact previous position?
IE8 to be friendlier that previous versions
How can I find the previous value of a cell after it has been chang
Simplest way to check for a blank worksheet in an excel workbook
delete duplicate PERSONAL workbook?
copied workbooks & links
How to merge workbooks
Max number of sheets in workbook?
Getting directory of current workbook (curdir does not do this)
workbooks.add
Workbook Tracking Question
Read-only Workbook
Read-only Workbook

Tagged:next workbook or previous

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us