| 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' Thanks very much |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| get path - save new file - same sub-directory as existing file | Excel Programming | |||
Linear Mode
