Macro To Open Additional Workbook

[chumley]

Hi all,

I have what is hopefully a fairly straight forward question that I am hoping someone can help me out with.

I am developing a macro that is stored in my Personal Macro Workbook, hence it can be run on any workbook with any naming convention. I would like it to do the following:

1) Launch the macro whilst in a workbook, the name of which is random
2) Open C:\Folder\Example.xls
3) Return to the original workbook

It is step 3 that i am having trouble with, as the filename could be something different every time.

Any help would be appreciated.

 

[Andrew Poulsom]

Before opening the other workbook assign the active workbook to an object variable like this:

Dim WB As Workbook
Set WB = ActiveWorkbook

Later you can activate that workbook like this:

WB.Activate

 

[kpark91]

You could set a workbook variable to your current workbook BEFORE you open a workbook (example.xls). So, that you can show it after you have opened it.

for example,

Dim WB As Workbook
 
Set WB = ActiveWorkbook
'Open a workbook
WB.Activate 'or show... I dunno

 

[chumley]

Worked a treat, thanks very much for the prompt response both of you.