View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon Davies Simon Davies is offline
external usenet poster
 
Posts: 1
Default 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