| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a Workbook within VB
Hi All,
I'm having a problem opening a file i VB. VB seems to want the full path name and I just want it to look for the file the is in the local folder that I'm running the VB from, but I don't know how to do this. I try: Workbooks.Open "test.xls" & VB wants: Workbooks.Open "C:\Folder\Test.xls" Can I get around this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Opening a Workbook within VB
ThisWorkbook.Path & "\" & Test.xls
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "NeedYourHelp" wrote in message Hi All, I'm having a problem opening a file i VB. VB seems to want the full path name and I just want it to look for the file the is in the local folder that I'm running the VB from, but I don't know how to do this. I try: Workbooks.Open "test.xls" & VB wants: Workbooks.Open "C:\Folder\Test.xls" Can I get around this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
| when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
| excel VBA problem - setting workbook as variable & opening/re-opening | Excel Programming | |||
| How to make the opening of a workbook conditional upon the opening of another workbook | Excel Programming | |||
| How to make opening of workbook conditional of opening of another workbook | Excel Programming | |||
Linear Mode
