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
--
TS

Simply Record a Macro while you open the desired Workbook.

TS wrote:

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

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

--
If this helps, please click "Yes"
<<<<<<<<<<<


"TS" wrote:

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
--
TS

Macro Recorder is your friend.


Gord Dibben MS Excel MVP

On Thu, 29 Oct 2009 09:58:01 -0700, TS wrote:

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