Sharing macros with other users

%3CLINGO-SUB%20id%3D%22lingo-sub-2155370%22%20slang%3D%22en-US%22%3ESharing%20macros%20with%20other%20users%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155370%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20have%20a%20macro%20which%20will%20create%20and%20populate%20a%20worksheet%20from%20numerous%20other%20sheets.%20I%20want%20to%20make%20this%20available%20to%20other%20users%20on%20the%20network%2C%20to%20be%20used%20on%20a%20regular%20basis%20on%20numerous%20identical%20workbooks.%20What's%20the%20simplest%20way%20of%20achieving%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEoghan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2155370%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi all,

I have a macro which will create and populate a worksheet from numerous other sheets. I want to make this available to other users on the network, to be used on a regular basis on numerous identical workbooks. What's the simplest way of achieving this?

 

Eoghan

3 Replies

@Eoghan93 

 

How can I call a macro of the B.xls workbook from the A.xls workbook?

 

Workbook A

Public Sub test()

Application.Run ("'B.xls'!test2")

End Sub

-------------------------------------------------

Workbook B

Public Sub test2()

MsgBox "OK….it runs :-)"

End Sub

 

Should actually work without problems, unless it is Excel Online in the game.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

 

@NikolinoDE Thanks, I'll give that a try

If you liked it and was helped by it, please mark and vote this answer as helpful as it will be beneficial for more community members reading here.

I am happy if I could help you even a little.

Nikolino
I know I don't know anything (Socrates)