Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA File Variables - User App directory
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.AddFrom File 'CurrentUserAppsDirectoryVariable\Microsoft\Excel\ XlStart\mydll.dll' and How to check with VBA if the reference already exists? Thanks very much |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA File Variables - User App directory | Excel Programming | |||
prompt user to specify a directory | Excel Programming | |||
Getting open file's directory, captureing user login ID, write access | Excel Programming | |||
Creating a Directory from a user input | Excel Programming | |||
Global Variables using User Forms | Excel Programming |