Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Path
Hi,
I use the following line to select a file to be opened in a piece of VB: dirpathIn = Application.Path + "\Blank Price List v1.1.xls" 'where the blank price list sheet is located This works perfectly on the 5 or so systems running Win2k and Office 2k/Excel 2k on different build levels, different ages, different general installations etc. However, it does not seem to work on the only machine that has XP and Office 2002/Excel 2002 and I need to hard code the path for the line to work. Question: Is this a known 'feature' of the 2k/2002 migration or have I just left something out.... Any help and suggestions gladly received. Regards, Simon email: removing 'junk' please |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Application.Path
Simon,
What do you mean when you say it doesn't work. Does it return an incorrect path? Does it return nothing? It works fine for me. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Simon Davies" wrote in message ... Hi, I use the following line to select a file to be opened in a piece of VB: dirpathIn = Application.Path + "\Blank Price List v1.1.xls" 'where the blank price list sheet is located This works perfectly on the 5 or so systems running Win2k and Office 2k/Excel 2k on different build levels, different ages, different general installations etc. However, it does not seem to work on the only machine that has XP and Office 2002/Excel 2002 and I need to hard code the path for the line to work. Question: Is this a known 'feature' of the 2k/2002 migration or have I just left something out.... Any help and suggestions gladly received. Regards, Simon email: removing 'junk' please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
how to change absolute path to relative path | Excel Worksheet Functions |