Getting excel to switch back to a workbook?

**cuewoz** · 04-24-2009, 01:18 PM

Hi I want to be able to use VBA to open a 2nd sheet when the spreadsheet first starts ,with

Please Login or Register  to view this content.

then switch back to the original one

I have

Please Login or Register  to view this content.

to get the sheets name but I dont know how to the use this to activate back

This doesn't work

Please Login or Register  to view this content.

The reason not to just put in the actual filename is the name can change and then it would crash out.

Any Ideas

**royUK** · 04-24-2009, 01:35 PM

You don't seem to know whether you are referring to a sheet or a workbook. Your first code opens a workbook, the second line returns the full name of the workbook contining the code. I think you want this

Please Login or Register  to view this content.

**cuewoz** · 04-25-2009, 04:03 AM

I am sorry, I think you misunderstood
my code together reads

Please Login or Register  to view this content.

to go from 1st workbook, then open 2nd workbook and switch straight back.
This is as the 1st workbook needs code on a 2nd workbook to function, so to make sure its open at the same time, I am adding this in.
So the Windows(MyFullName).Activate bit should show the 1st workbook again.

**royUK** · 04-25-2009, 04:25 AM

Thisworkbook will activate the workbook that contains the code, I would think that is the first workbook.

**cuewoz** · 04-25-2009, 04:51 AM

I just tried

Please Login or Register  to view this content.

and it doesn't work ,the presents sheet remains open, how should I type it please?

**royUK** · 04-25-2009, 05:01 AM

You haven't copied the code that I gave you
[ThisWorkBook.Activate[/code]

**mudraker** · 04-25-2009, 05:19 AM

If you described fully what you are doing you may not need to activate the workbook.

MAcro code is more efficient if you can avoid selecting & activating books, sheets, cells etc

**cuewoz** · 04-25-2009, 05:41 AM

Sorry , that works now.

The reason I need to activate the other sheet is my manager wants this workbook as a stand alone book which has been verified as working correctly and wouldn't let me copy it into new workbook, so I just need to have both open together.

Seems to have cracked it now though.
Thanks

**royUK** · 04-25-2009, 05:51 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save