VBA File Variables - User App directory

  • Thread starter Chris Leroquais
  • Start date
C

Chris Leroquais

Hi there,

do you know how I can specify the Windows User App directory in an Excel VBA
macro?
What is the variable to use? (VBA API or Windows environment variables?)

In my case I want to code something like that:

Application.VBE.ActiveVBProject.References.AddFromFile
'CurrentUserAppsDirectoryVariable\Microsoft\Excel\XlStart\mydll.dll'

Thanks very much
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA File Variables - User App directory 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
VBA for updating Resource's ActualWork 0
Inability to add quotation mark around a variable by concatenation in VBA 4
Toggling save warning message on or off 9
Weird Behaviour of Compiler Directives? 14
Need VBA Macro to Loop through pages and print counter in footer of each page 9
VBA to run all variable combinations in a calculation model and store result 6

Top