Activate Excel Sheet through Visual Basic 2008

[Sniper]

Good Evening

I am using Visual Basic 2008 to run some macros on excel sheets. I have no problem opening an excel sheet

Please Login or Register  to view this content.

my problem comes when I am trying to activate an already opened (test.xls) sheet. The code I have that's getting very close is

Please Login or Register  to view this content.

How do I just activate the "test.xls" sheet

Thanks

[AlvaroSiza]

Be sure to distinguish between Workbooks(or "books") and Worksheets(or "Sheets") as these are two seperate collections, the second a child of the first.

How do I just activate the "test.xls" sheet?

Do you mean that you would like to activate a specific worksheet within the test.xls workbook?

[Sniper]

sorry what I mean is that I want to activate the actual workbook, but you have a point there.....once I activated the workbook I will have to activate certain sheets within the workbook.

Thanks

[Sniper]

this is another code I have but I get nothing out of this, the code looks like it should do the trick but all it does is open another excel process

Please Login or Register  to view this content.

[AlvaroSiza]

Something like this should allow you to activate an already open, but not primary workbook

Please Login or Register  to view this content.

Once the correct (already open, but not activated) workbook is activated, it will be ThisWorkbook, so you could then activate a sheet via:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[JosephP]

you need getobject instead of createobject to get a reference to a running instance though you could just add wb.activate to your original code I reckon.

[Sniper]

I am lost, nothing works

[JosephP]

what happens if you use wb.activate at the end of the second bit of code in your first post? ("nothing works" doesn't help us to help you)

[Sniper]

if I add wb.activate it adds the () and doesn't do anything, it's like I added a button with no code. I think my problem is with

Please Login or Register  to view this content.

[JosephP]

it won't bring the excel application to the foreground if it isn't already there but it should activate that workbook within the application. it shouldn't really be necessary to activate anything though.

[Sniper]

I see what you mean, why would it not bring the actual application to the foreground? you see my problem is that I will have a few sheets open and the data will run between the sheets with some code. I guess if it activates the workbook the code can continue moving data am I right?

[JosephP]

because you haven't told it to-you've only really changed the z order of the child workbook window
your code should specify the workbook instead of relying on the activeworkbook being the right one but activating within the app should work, since that's where the code will run.

[Sniper]

but how do you tell it to? I have tried select, show, visible = true and none of them brings it to the foreground. Am i missing something? I went back to this code because it makes more sense.

Please Login or Register  to view this content.

yet it doesn't bring it to the foreground.

[JosephP]

that code creates a new instance of excel so there won't be any workbooks open in it anyway (except maybe a blank Book1)