Sleeper: Change login path for distributing other loggers

[ilyaskazi]

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]

Use this to build your path.

Application.StartupPath

[ilyaskazi]

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]

Can you give an example of a path you would use?

[ilyaskazi]

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]

help...

[Jacob Hilderbrand]

See if this Article is of any use to you.

[ilyaskazi]

So sorry, its of no use. it was the only basic guidance and not the solution to my problem.

[Jacob Hilderbrand]

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.