Click the button and open the file in a separate Excel window

Hi, guys.

My sheet has some buttons, they all open a new workbook. It's the same workbook for all the buttons, but each one has a hyperlink to a different named range in this workbook.

The problem is the workbook asked to open does it in the same window. I need something to open it in a separate window so that I can view the current file and the new file separatedly.

I tried running some macros I found searching the web, linking the buttons to them, but none of them worked.

Any help? Thank you so much.

Originally Posted by LJMetzger

Hi Lewis,

The Macro 'Select_File_Or_Files_Windows()' at the following link works for me using Vista 32 bit system and Excel 2003.
http://msdn.microsoft.com/en-us/libr...ice.14%29.aspx

Lewis (M)

Hi, LJMetzger! Thank you for replying!

This macro is fine, but it's not what I'm looking for. Maybe I'm quite ambiguous about my issue, sorry. :P

This macro prompts a window to select a file. I don't want that, I want a macro which will open a new workbook, a specified file, in a new window.

Hi again,

It's just as well that my previous post didn't suit your needs, because I was wrong - see retraction above.

However, I did find the following code, that does work (Vista 32 bit using Excel 2003) courtesy of Andy Pope circa 2003. Thanks again Andy.

Lewis

Change to path and file name below to suit your needs.

Please Login or Register  to view this content.

I believe this is not a hard thing to do. It's cause as I am not an expert in VBA, I don't know how to proceed.

I think I'd need something like 'sPath', or 'sFileName' to define my Range. Something like 'sRange' (?). I just don't know how it is called. In case someone knows, e-mail me ([email protected]) or send me a PM, I will thank you forever.

But, as no one seems to have the answer, I'm marking this thread as solved, since the big problem doesn't exist anymore. I can open my workbook in a separate window.

I am going to delete the 10 buttons I have and replace them for one button only which will open the second workbook in a separate window.

I will add 10 buttons to this second workbook and I will hyperlink them to their ranges.

Thank you so much for your help, LJMetzger (just added rep to you, thanks), and thanks to Andy Pope too, for your courtesy.

Hi Lewis,

Every time I post to you, it feels like I'm talking to myself.

I was able to create a pseudo-hyperlink to an Excel file in an separate instance of Excel if the destination file is 'Macro Enabled' and has a special macro in the 'Workbook_Open' module. I did this by creating a 'scratch' Excel file that is written to by the calling 'Excel File' and read by the destination 'Excel file'. I attached two workbooks and the code follows here.

Lewis

Workbook_Open() in the Destination File:

Please Login or Register  to view this content.

Example Code for the Buttons in the Calling Excel file:

Please Login or Register  to view this content.

Code that does the work in the calling Excel file:

Please Login or Register  to view this content.

Thank you so much, this is awesome!