Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using environment variable in macropath
Hiho,
i have a problem with a macro which is linked behind an excel button. I want to use the environment variable %USERPROFILE% in the macro path because the macro is been used from many users. The path at this time is hard coded: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\Anwendungsdaten\Microsoft\Excel\XLStart\PE RSONL.XLS I want to modify the path to: %USERPROFILE%\Anwendungsdaten\Microsoft\Excel\XLSt art\PERSONL.XLS When i modify the path the result is the following: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\%USERPOROFILE%\Anwendungsdaten\Microsoft\E xcel\XLStart\PERSONL.XLS Any hints how to solve this ? Thx Markus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using environment variable in macropath
sFile = environ("USERPROFILE") _
& "\Anwendungsdaten\Microsoft\Excel\XLStart\PERSONL. XLS" -- regards, Tom Ogilvy "M. Mix" wrote: Hiho, i have a problem with a macro which is linked behind an excel button. I want to use the environment variable %USERPROFILE% in the macro path because the macro is been used from many users. The path at this time is hard coded: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\Anwendungsdaten\Microsoft\Excel\XLStart\PE RSONL.XLS I want to modify the path to: %USERPROFILE%\Anwendungsdaten\Microsoft\Excel\XLSt art\PERSONL.XLS When i modify the path the result is the following: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\%USERPOROFILE%\Anwendungsdaten\Microsoft\E xcel\XLStart\PERSONL.XLS Any hints how to solve this ? Thx Markus |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
using environment variable in macropath
good morning!
Tom, unfotunately i donīt know what you mean. I have a button in Excel. Behind the button i need the macropath described below. I cant use code in the path or am i wrong? Maybe i choose the wrong subnewsgroup :-/ i am sorry. ` Thanks Markus "Tom Ogilvy" schrieb im Newsbeitrag ... sFile = environ("USERPROFILE") _ & "\Anwendungsdaten\Microsoft\Excel\XLStart\PERSONL. XLS" -- regards, Tom Ogilvy "M. Mix" wrote: Hiho, i have a problem with a macro which is linked behind an excel button. I want to use the environment variable %USERPROFILE% in the macro path because the macro is been used from many users. The path at this time is hard coded: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\Anwendungsdaten\Microsoft\Excel\XLStart\PE RSONL.XLS I want to modify the path to: %USERPROFILE%\Anwendungsdaten\Microsoft\Excel\XLSt art\PERSONL.XLS When i modify the path the result is the following: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\%USERPOROFILE%\Anwendungsdaten\Microsoft\E xcel\XLStart\PERSONL.XLS Any hints how to solve this ? Thx Markus |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
using environment variable in macropath
Markus,
If you are trying to run a routine in ..XLStart\Personal.xls, it will be open and the path is irrelevant. Use Application.Run "Personal.xls!YourRoutine" Otherwise, you cannot run code in a workbook that is not open. NickHK "M. Mix" wrote in message ... good morning! Tom, unfotunately i donīt know what you mean. I have a button in Excel. Behind the button i need the macropath described below. I cant use code in the path or am i wrong? Maybe i choose the wrong subnewsgroup :-/ i am sorry. ` Thanks Markus "Tom Ogilvy" schrieb im Newsbeitrag ... sFile = environ("USERPROFILE") _ & "\Anwendungsdaten\Microsoft\Excel\XLStart\PERSONL. XLS" -- regards, Tom Ogilvy "M. Mix" wrote: Hiho, i have a problem with a macro which is linked behind an excel button. I want to use the environment variable %USERPROFILE% in the macro path because the macro is been used from many users. The path at this time is hard coded: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\Anwendungsdaten\Microsoft\Excel\XLStart\PE RSONL.XLS I want to modify the path to: %USERPROFILE%\Anwendungsdaten\Microsoft\Excel\XLSt art\PERSONL.XLS When i modify the path the result is the following: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\%USERPOROFILE%\Anwendungsdaten\Microsoft\E xcel\XLStart\PERSONL.XLS Any hints how to solve this ? Thx Markus |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
using environment variable in macropath
Hi Nick,
that donīt work. I can fill in the path as you described but if you refresh the view or reopen the button and look at the path you see that the path is deposited as hard coded path. Still having the inicial problem :-/ But thank you for the idea. I cant imagine that i am the only one with that problem. How are the otherone handling with the issue of personalized macroīs and its path? Maybe i have to take a different way to the goal. Thanks Markus "NickHK" schrieb im Newsbeitrag ... Markus, If you are trying to run a routine in ..XLStart\Personal.xls, it will be open and the path is irrelevant. Use Application.Run "Personal.xls!YourRoutine" Otherwise, you cannot run code in a workbook that is not open. NickHK "M. Mix" wrote in message ... good morning! Tom, unfotunately i donīt know what you mean. I have a button in Excel. Behind the button i need the macropath described below. I cant use code in the path or am i wrong? Maybe i choose the wrong subnewsgroup :-/ i am sorry. ` Thanks Markus "Tom Ogilvy" schrieb im Newsbeitrag ... sFile = environ("USERPROFILE") _ & "\Anwendungsdaten\Microsoft\Excel\XLStart\PERSONL. XLS" -- regards, Tom Ogilvy "M. Mix" wrote: Hiho, i have a problem with a macro which is linked behind an excel button. I want to use the environment variable %USERPROFILE% in the macro path because the macro is been used from many users. The path at this time is hard coded: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\Anwendungsdaten\Microsoft\Excel\XLStart\PE RSONL.XLS I want to modify the path to: %USERPROFILE%\Anwendungsdaten\Microsoft\Excel\XLSt art\PERSONL.XLS When i modify the path the result is the following: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\%USERPOROFILE%\Anwendungsdaten\Microsoft\E xcel\XLStart\PERSONL.XLS Any hints how to solve this ? Thx Markus |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
using environment variable in macropath
Hi Markus,
perhaps Application.DefaultFilePath see if http://www.mvps.org/dmcritchie/excel/property.htm is of any help to you. David McRitchie On Feb 6, 2:30 am, "M. Mix" wrote: Hi Nick, that donīt work. I can fill in the path as you described but if you refresh the view or reopen the button and look at the path you see that the path is deposited as hard coded path. Still having the inicial problem :-/ But thank you for the idea. I cant imagine that i am the only one with that problem. How are the otherone handling with the issue of personalized macroīs and its path? Maybe i have to take a different way to the goal. Thanks Markus "NickHK" schrieb im . gbl... Markus, If you are trying to run a routine in ..XLStart\Personal.xls, it will be open and the path is irrelevant. Use Application.Run "Personal.xls!YourRoutine" Otherwise, you cannot run code in a workbook that is not open. NickHK "M. Mix" wrote in message ... good morning! Tom, unfotunately i donīt know what you mean. I have a button in Excel. Behind the button i need the macropath described below. I cant use code in the path or am i wrong? Maybe i choose the wrong subnewsgroup :-/ i am sorry. ` Thanks Markus "Tom Ogilvy" schrieb im Newsbeitrag ... sFile = environ("USERPROFILE") _ & "\Anwendungsdaten\Microsoft\Excel\XLStart\PERSONL. XLS" -- regards, Tom Ogilvy "M. Mix" wrote: Hiho, i have a problem with a macro which is linked behind an excel button. I want to use the environment variable %USERPROFILE% in the macro path because the macro is been used from many users. The path at this time is hard coded: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\Anwendungsdaten\Microsoft\Excel\XLStart\PE RSONL.XLS I want to modify the path to: %USERPROFILE%\Anwendungsdaten\Microsoft\Excel\XLSt art\PERSONL.XLS When i modify the path the result is the following: C:\Dokumente und Einstellungen\mmustermann\Eigene Dateien\%USERPOROFILE%\Anwendungsdaten\Microsoft\E xcel\XLStart\PERSONL.XLS Any hints how to solve this ? Thx Markus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding temp folder. Environment variable? | Excel Programming | |||
Environment Variable Names | Excel Programming | |||
Can you set a Window's Environment variable in VB | Excel Programming | |||
Environment Variable | Excel Programming | |||
How can I invoke windows environment variable in excel | Excel Programming |