Macro to open seperate workbook

[TS]

I have not been able to create a macro to open a seperate workbook
I am in workbook A and would like to run a macro that will open workbook B

 

[Bob I]

Simply Record a Macro while you open the desired Workbook.

 

[BSc Chem Eng Rick]

Here you go. Please note that MyWB is a string variable which is the path of
the workbook you wish to open.

Sub WBOpen()
Dim MyWB As String
MyWB = "C:\Documents and Settings\Rick\My Documents\UpdatedOPEX.xls"
Workbooks.Open MyWB
End Sub

 

[Gord Dibben]

Macro Recorder is your friend.


Gord Dibben MS Excel MVP