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'

and How to check with VBA if the reference already exists?

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
Need VBA Macro to Loop through pages and print counter in footer of each page 9
execution speed issue when closing files 5
Referencing other Office programs in a Excel VBA App 2
Cannot find a loaded VBA addin 3
Chart label alignment 0
location for XLA's that I can easily get to 7

Top