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 |
All times are GMT +1. The time now is 06:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com