View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Simon[_12_] Simon[_12_] is offline
external usenet poster
 
Posts: 1
Default Application.Path in Excel 2k and 2002

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