Activate Open Workbook

My code currently opens any workbook, document, video, etc. from 1 button. When it comes to opening a file that is already open, it gives the following message.

"This File Is Already Open"

I want to convert the code to activate (Display) the non-displayed workbook. In my sample code, I have 2 rows of rem'd X's to show where the problem is, I think.

'xxxxxxxxxxxxxxxxxxxxxxxxxxx

Questionable Code

'xxxxxxxxxxxxxxxxxxxxxxxxxxx

Please Login or Register  to view this content.

Leith are you around?

Hello Matt,

My guess is the file you are trying to activate has been opened in separate instance of Excel. ActiveWorkbook will only display workbooks open in the current instance of Excel. If memory serves me correctly, I wrote a macro for you to do this. almost a year ago. Here it is again...

Please Login or Register  to view this content.

Macro Example

Please Login or Register  to view this content.

Thanks Leith . . . Your memory is correct, I am opening separage instances of Excel. I am using the code you gave me for opening all files where I directly open a workbook using the file name. Love it and it works great.

I have this one button though, that you helped me with to open any file, Excel or Word as examples, where I have selected the name of the file in a cell, with the path & file name one cell to the left..

I was hoping that I could modify the existing macro so it didn't have to be totally re-written. I don't think that the code you referenced will work for this application.

Do you need any other information to evaluate this?

P.S. I'll be sending you my eMail program this coming week. Just doing cleanup and decor. My beta test people love it.

Please Bump Up