Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening a workbook in the current directory
I'm trying to determine whether or not this can be done using VBA:
Using Windows Explorer, say, I double-click to open an Excel file located in a directory other than the default Excel directory. In this workbook is VBA code that attempts to open another workbook located in the same directory: Workbooks.Open "XYZ.xls" The operation fails, apparently because it's looking in the default Excel directory. Is there a way to specify that the program look in the current, working directory? Rich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening a workbook in the current directory
Richard
Try.... Workbooks.Open ThisWorkBook.Path & "\XYZ.xls" -- XL2002 Regards William "Richard" wrote in message ... | I'm trying to determine whether or not this can be done using VBA: | | Using Windows Explorer, say, I double-click to open an Excel file | located in a directory other than the default Excel directory. In this | workbook is VBA code that attempts to open another workbook located in | the same directory: | | Workbooks.Open "XYZ.xls" | | The operation fails, apparently because it's looking in the default | Excel directory. Is there a way to specify that the program look in the | current, working directory? | | Rich |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening a workbook in the current directory
Try to set a path variable inside of a procedure.
strPath = ThisWorkbook.Path That will set the path to the current workbook. I've used that successfully, but be warned... I've tried to set a private form wide variable to do this to use between different procedures and the variable doesn't keep itself intact. I can't figure out what the deal is with that, but I get around it by declaring (Dim) the variable in every procedure I need it and force the ThisWorkbook.Path into it. -- Jim Carlock http://www.microcosmotalk.com Feel free to post back to the newsgroup! "Richard" wrote in message ... I'm trying to determine whether or not this can be done using VBA: Using Windows Explorer, say, I double-click to open an Excel file located in a directory other than the default Excel directory. In this workbook is VBA code that attempts to open another workbook located in the same directory: Workbooks.Open "XYZ.xls" The operation fails, apparently because it's looking in the default Excel directory. Is there a way to specify that the program look in the current, working directory? Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a spreadsheet recognize the current directory it is in? | Excel Discussion (Misc queries) | |||
current directory | Excel Discussion (Misc queries) | |||
Current Directory | Excel Discussion (Misc queries) | |||
Update Links to current Directory?? | Excel Discussion (Misc queries) | |||
OPENING A FILE LOCATED IN A DIRECTORY DIFFERENT FROM CURRENT DIRECTORS | Excel Programming |