Hi All..........

I'm trying to open a workbook from a Path that is subject to change, and is
therefore entered by the user in cell MainMenu!H30. I've tried this, with
the Path in the referenced cell, but no joy.

Workbooks.Open FileName:=Range("MainMenu!h30").Value & "\MyFileName.XLS"

I get a pop-up saying that the correct path and filename "could not be found".
but if I hardcode the same path and filename it works fine


Any help would be much appreciated.

Vaya con Dios,
Chuck, CABGx3