Excel path in Outlook

[Trefor]

In Excel I use "Application.UserLibraryPath" as part of a path to a file. Is
there an equivalent on Outlook that will take me to the same place?

I actually want to get to "C:\Documents and Settings\<username>\Application
Data\"

 

[JP]

Application.VBE.ActiveVBProject.References.Item("Excel").FullPath

returns the path to the Excel object library, which in Excel's case is
the Excel executable file itself. Assuming, of course, you have set a
reference to the Excel object library in Outlook.

Does that help?

--JP

 

[Trefor]

JP,

Not really, but I found the following that will do the trick:

UserFile = "C:\Documents and Settings\" & Environ("username") &
"\Application Data\......."

 

[Dmitry Streblechenko]

"Application Data" is locale specific and will be different under
non-English versions of Windows.

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-

 

[Sue Mosher [MVP-Outlook]]

It's also different in different operating systems. Try using Environ("appdata") instead.

 

[Trefor]

Sue / Dmitry,

Thanks for you comments.

In my case the file I am looking for was put there using the same path and
my code is only deployed in 2000/XP Office 2003 environments, but I take your
point.

Thanks.

--
Trefor

It's also different in different operating systems. Try using Environ("appdata") instead.