VBA If Then Cell Value From Another Open Workbook

[Mcook13]

Hello Excel Wizards,

I am trying to write an If Then statement in VBA to have my workbook save in the appropriate file location depending on the cell value of another open workbook.

I have 2 open workbooks. The one workbook (call it "Wbk A") I am saving has to reference the cell value in the other open workbook (call it "Wbk B"). If Wbk B's cell value equals X, then Wbk A will follow a specific save file path. Or a different save file path if Wbk B's cell value equals Y.

The part I am having trouble writing is the portion of the code to say if Wbk B's cell value (in L2 to be exact) equals X....

I know how to write the Then portion since that is the save file path.

Thank you for any and all help!

 

[6StringJazzer]

Do you have the second workbook assigned to a Workbook object in your code? If so then

If WbkB.Worksheets("MySheet").Range("L2") = "X" Then

If not then

If Workbooks("Wbk B.xlsx").Worksheets("MySheet").Range("L2") = "X" Then

It's a pretty generic answer but then again the question is a bit generic. If you show the code you already have I could be more specific.

 

[Mcook13]

Thank you 6StringJazzer.
I used the below code and it worked.

If Workbooks("Wbk B.xlsx").Worksheets("MySheet").Range("L2") = "X" Then