Open workbook in the same directory using workbooks.open

[saugui]

Hi,

Can Workbooks.open search for the file in the current directory of the workbook that is running the Macro?

The scenario is I have a Macro which will run on opening a FileA. The Macro should open FileB. FileB is always in the same directory as FileA.

I have tried Workbooks.Open Filename:="FileB.xls", ReadOnly:=True. But when I run the Macro, it gives me a "file not found" error.

Can someone help?

Thanks.

[Simon Lloyd]

Try this:

Please Login or Register  to view this content.

Regards,
Simon

[saugui]

It works. Thanks.