Macro Installation!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim - 28 Oct 2004 18:17 GMT

I know excel quite a bit , currently am using Excel 2003 but i dont know if
get a Macro code built in VBA, i wish to know how do i run it? i know i have
to paste the code in a module but what to do after that? should i save it
or just return to excel?

also what if i want to re run that code? what guidelines and procedures
needs to be followed?

i know many of you are familiar with this , but pls enlighten me also!

thanks in advance!

jim

Reply to this Message

Dave Peterson - 28 Oct 2004 18:25 GMT

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

But once your back in excel, you can hit tools|macro|macros...

Select the one you want and click Run.

(I usually save the workbook after I've pasted code, but before I run it. If it
doesn't do what I want, I can always close without saving, reopen it, modify the
code, save, and rerun it.)

> I know excel quite a bit , currently am using Excel 2003 but i dont know if
> get a Macro code built in VBA, i wish to know how do i run it? i know i have
[quoted text clipped - 9 lines]
>
> jim

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message