Application.Path in Excel 2k and 2002

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

Simon

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
 
It seems odd to use application.path for this. Maybe you should be using
ThisWorkbook.Path.
 
Back
Top