Application.Path

  • Thread starter Thread starter Simon Davies
  • Start date Start date
S

Simon Davies

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:


(e-mail address removed) removing 'junk' please
 
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
 
Back
Top