Open Workbooks present in the same directory
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. |
Open Workbooks present in the same directory
On Apr 30, 12:51 pm, wrote:
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... |
Open Workbooks present in the same directory
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 ? |
Open Workbooks present in the same directory
On Apr 30, 11:14 pm, wrote:
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 |
All times are GMT +1. The time now is 06:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com