View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 38
Default ThisWorkbook.Path & Windows Vista

Hello

I am using Windows Vista and Excel 2000, XP, 2003 & 2007.

Now I created an Excel add-in and copied it to the following directory:

C:\Programme\XY\


At next I opened this Excel file and went to the Visual Basic editor. I
entered the command "ThisWorkbook.Path" to test where my add-in is stored -
the system returned the following path:

C:\Program Files\XY\


?!?!? I do not have such a directory (Programme is the german name of
Program Files). I suppose that this has something to do with Windows Vista.
How can I get the path of my add-in Windows Vista? The command has to run in
Windows XP & Windows Vista? Many thanks in advance.

Thomas