PDA

View Full Version : Sleeper: Change login path for distributing other loggers



ilyaskazi
03-25-2005, 09:27 AM
I hv to set macro paths everytime to other computer loggers assigned under my computer login.

Is there any other quick solution to this?? so that if I distribute my macro file (startup file) to others, they can run my macro under their login name.

Jacob Hilderbrand
03-25-2005, 09:40 AM
Use this to build your path.

Application.StartupPath

ilyaskazi
03-27-2005, 09:36 PM
can u guide me this in little details plz...

where to put the above code and from where to execute??

Is there any other instruction i hv to write for changing the path???

Jacob Hilderbrand
03-27-2005, 10:25 PM
Can you give an example of a path you would use?

ilyaskazi
03-28-2005, 12:30 AM
If I run macro under my computer login, suppose "ILYAS" it works fine.

If I run macro under other login name, suppose "KUSHAL" it keeps telling,
"The macro "C:\Documents and Settings\ILYAS\Application Data\Microsoft
\Excel\XLSTART\PERSONAL.XLS'!Macro1' cannot be found."

This happens when I click any shortcut button on toolbar to run my macro.

While, if it is assigned with any shortcut key, then it works fine.

Then I hv to give path for each and every shortcut button on toolbar by right-clicking and assigning the macro with current login name (i.e KUSHAL).

ilyaskazi
03-28-2005, 07:25 AM
help...: pray2:

Jacob Hilderbrand
03-29-2005, 03:59 PM
See if this Article (http://www.vbaexpress.com/forum/articles.php?action=viewarticle&artid=18) is of any use to you.

ilyaskazi
03-29-2005, 08:07 PM
So sorry, its of no use. it was the only basic guidance and not the solution to my problem.

Jacob Hilderbrand
03-29-2005, 08:23 PM
Sorry, I must have been thinking about something else.

What you should do is put the code in an Add-In.

Put the code in a workbook then save the workbook as an Add-In. Then you can distribute the Add-In and each user can install it if they want to use it.

If you need help converting the code to work with an Add-In, just post the code that you are using.