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

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