Can one or two macros do all this through email?

**duugg** · 03-18-2009, 02:32 PM

Hello all,

I have a fellow collegue named Brianna who works in a different location than me who needs to automate a task in Excel 2003. Brianna is not that knowledgable in Excel other than the very basics. Therefore, I would like to email her a file/files that can accomplish this task for her with very minimal effort on her part. Here's what I need...

I need to create a new toolbar in Brianna's Personal workbook named "Food".
I then need to create a toolbar button (on the "Food" toolbar) named "Fruit".
I then need the "Fruit" button to execute a macro named "Orange".

Here is the "Orange" macro...

Code:

Sub Orange()
    ActiveCell.FormulaR1C1 = "Orange"
    Range("D2").Select
End Sub

Can this be done?
Kudos to anyone that can pull this one off!

Thanks much,

duugg

**royUK** · 03-18-2009, 02:39 PM

You need to create n excel addin

**duugg** · 03-18-2009, 02:45 PM

Assuming someone like myself has no knowledge of building macros/formulas, is there a step by step process that you can provide to get this done? I wouldn't even know where to begin.

Thanks much

**Leith Ross** · 03-18-2009, 10:40 PM

Hello Duugg,

It seems like once the workbook is created, you could email mail it to her with instructions. I really don't see any need to create an Add-In. Would this work for you?

**duugg** · 03-18-2009, 11:07 PM

Well, to be honest, I will have the same set of macros that I would like to give to multiple people. I figured that there had to be some way of sending them a file and have everything mentioned above execute with any user intervention. Is there any way to do this?

If it's an add-on, I wouldn't have a clue where to start. It took me awhile just to get the whole module/code thing down.

I want to be able to send multiple people a file, have this file install a macro in their personal workbook, create a toolbar with a button that they press to come up with a list of macros that I have created. I want this to show up no matter what workbook they have open which is why I think the Personal Workbook is necessary.

Is this even doable or am I way off base to think that this can be done?

Thanks

**Leith Ross** · 03-18-2009, 11:26 PM

Hello Duugg,

In that case, Roy is right. An Add-In would be the way to go. The Add-In will allow the user to run your macros and access your toolbar without modify their workbooks. The user will still have to save the workbook in the correct folder after you email it.

**duugg** · 03-19-2009, 09:42 AM

Okay,

Soooo, having said that...is there some code that I can copy and paste to make this happen with an add-in. Let's say I want to get the "Orange" macro to a user's computer...what is the

step-by-step

process I would need to get this done?

Thanks

**duugg** · 07-11-2009, 10:10 PM

bump, no response

This is an old thread but one that I would still love to know the answer to, if it's a fairly simple one. Anyone want to take a crack at this one?

thanks