windows.activate doesn't work in excel 2010

[rnl0085]

after a recent upgrade to excel 2010 suddenly the windows(excel file name).activate function doesn't work anymore..

i run a macro, open another file, do something, close the other file, and then try to activate the old file again from which the macro in first instance was run...however when i put a ' in front of the windows activate line it works again..

has anyone seen this before?

 

[Domenic]

I have Excel 2010 and Windows("Filename").Activate works just fine. Try posting your code and someone should be able to pinpoint the problem.

 

[wigi]

In what situation would you want to use that Windows().Activate?

 

[Cindy Ellis]

Your settings to "hide extensions" may have changed. Take a close look at the banner at the top of the window (the text before " - Microsoft Excel") to see if the file name as shown is the same as the filename captured in the macro.
I don't think there's a way to access the setting from within Excel. In File Manager, it's under "Tools" "Folder Options" "View". If the macro includes the extension in the filename, uncheck the box for "Hide extension for known file types".
Hope that helps,
Cindy

 

[rnl0085]

thanks, i will look at the extension property tomorrow (at another pc)

i use it to switch between different excel files, if you have more excel files open, that it knows which file to switch to (and perform in a sheet in that file a new operation/macro/code)

 

[wigi]

And why not handling all files in one and the same window?

 

[Norie]

There should be no need to activate or select anything to do this.

You can easily create references to the relevant workbook, the workbook the code is in and the workbook being opened.

Then you can use those throughout the code when you need to refer to those workbooks.

Finally you close the workbook that was opened and you should be back where you started.