I have an Active Workbook, name of the workbook will be changing (so cannot apply macro on Workbook name), but macros will stay same. On Active Workbook (eg. on Sheet2) I would need a Macro that opens another Workbook (eg. WB2.xlsx ) but "cursor" should stay on the Sheet in that Active Workbook from where the macro is activated.
Then I would try to find "CLOSE" macro meaning when I close my Active Workbook also file WB2 closes.
Thank you for suggestions,
Set the Active workbook in a variable and also the activecell in a variable and use that variables to select the actual workbook and cell
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
First part I've solved that way:
Application.Workbooks.Open ("C:\...\WB2.xlsx")
ThisWorkbook.Activate
How to apply operation for "closing"?
Last edited by Tona; 10-29-2014 at 06:29 AM.
Basically...(I hope)
I missed the last part, sorry. Basically what Sixthsense said
Please Login or Register to view this content.
Last edited by Templemind; 10-29-2014 at 06:37 AM.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks