reference another workbook in VBA

[seeker123]

Hi everyone

I have several excel files open and I have a workbook named "Master" ,that workbook has a sheet called "Data Base", I want to activate the workbook that its name is in the cell(1,3) of "Data Base" worksheet I had wrote the code below

Workbooks(Workbooks("Master").Worksheets("Data Base").Cells(1, 3).Text + ".xlsm").Activate


but I get "Subscript out of range" error.
I know this is a reference error because when I type the workbook name it works.
Any ideas how I can solve this?

thanks in advance

 

[MARK858]

The code works fine for me. Are you 100% certain that the filename in C1 is 100% correct (including the spaces in the name and any leading or trailing spaces) and the workbook is open.

Does the code below give you exactly what you expect?

Sub xxx()
MsgBox Workbooks(Workbooks("Master").Worksheets("Data Base").Cells(1, 3).Text + ".xlsm").FullName
End Sub

 

[MARK858]

Actually open Workbook master and put both the codes below in the same module and make sure that your immediate window is open.
Run the first code.
Open the other workbook and run the second code.

Do they exactly match

Sub xxx1()
Dim i As String
i = Workbooks("Master").Worksheets("Data Base").Cells(1, 3).Text + ".xlsm"
Debug.Print i
End Sub

Sub xxx2()
Dim x As String
x = ActiveWorkbook.Name
Debug.Print x
End Sub

 

[seeker123]

Mark Thanks for your reply.

I just changed the "Master" to "Master.Xlsm" and it worked.!!
Thanks alot.

 

[MARK858]

Happy you worked it out for yourself