Open Workbooks present in the same directory

[cbalajii]

Hi,

I am creating a macro that will use data that resides in the same
directory as the file that has the macro code.

My Macro runs like this:

Workbooks.Open "Slash Daily Case Closed.xls"

When I open the file (reports.xls) from explorer and run the macro it
gives me error 1004.

However, when i use File Open and open reports.xls, the macro runs
perfectly fine.

Any help would be greatly appreciated.

 

[okrob]

Hi,

I am creating a macro that will use data that resides in the same
directory as the file that has the macro code.

My Macro runs like this:

Workbooks.Open "Slash Daily Case Closed.xls"

When I open the file (reports.xls) from explorer and run the macro it
gives me error 1004.

However, when i use File Open and open reports.xls, the macro runs
perfectly fine.

Any help would be greatly appreciated.

You need to give the full path... Workbooks.Open "C:\Documents and
Settings\Admin\Desktop\reports.xls" and it'll work both ways...

 

[cbalajii]

I wont be able to give full path because I am creating a report that
multiple people will be running and using this macro... is there an
alternate method ?

 

[cbalajii]

I wont be able to give full path because I am creating a report that
multiple people will be running and using this macro... is there an
alternate method ?

From the following website:

http://www.excel-vba.com/vba-12-code-workbooks.htm
******************start quote************

Opening Workbooks

To open another Excel file (workbook) with a VBA procedure you simply
write (notice that "Workbooks" is plural):
Workbooks.Open "suchAndSuch.xls"
You don't need to specify a directory (path) if the second workbook
resides in the same directory as "ThisWorkbook"

******************end quote************

So, when I open a file from a folder, then I should be able to just
open other files in the same directory ?

Balajii