Re Use of Macros in MS Excel

Asked By majellarichards 30 points N/A Posted on - 03/24/2012

 

Dear Friends, I am creating Macros in MS Excel and I want to reuse them in my other MS Excel file. Can anyone help me out whether I can reuse macros again for the same work? Or I have to create same macro again and again.

• Status: Open
• Question Views: 1353
• Answer Count: 11
• Vote Up 3 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Valbuena jane

Go To Solution

Best Answer

Best Answer

Answered By Valbuena jane 5 points N/A #91119

Re Use of Macros in MS Excel

Macros are the footage of the mouse movements and the clicks that copies your work automatically. If you have made a Macro from the past and you want to utilize it again, you just need to save it on your personal macro workbook. A new workbook will be made and will be named as personal.xls by default. It will be made on the AutoOpen directory on Excel. It will be launched automatically as soon as you start your computer. Start Excel and then click on the Menu and Unhide. The workbook is listed there. Click on Tools and then Macros to view all the Macros saved on file.

 

About Valbuena jane

Questions
5

Answers
62

Best Answers
18

• Vote Up 0 Vote Down

• Posted on - 03/25/2012
• Question Category: MS Excel

Answered By majellarichards 30 points N/A #91120

Re Use of Macros in MS Excel

Thanks a lot Valbuena Jane!

I tried it out and it works. Now I don't have to worry when I'm recording all our sales and inventory of excel files. Made my job a lot easier. I'm lucky I stumbled upon this site. Thanks again!

About majellarichards

Questions
6

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Excel

Answered By jamesaffron 20 points N/A #91122

Re Use of Macros in MS Excel

Wow! I didn't know that before I stumbled here on techyv. I thought I know excel well but all I know was to use the "save as" button and overwrite the newly saved one. Well done Jane. Thank you! 😉

About jamesaffron

Questions
6

Answers
6

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Excel

Answered By davidsonriley 0 points N/A #91121

Re Use of Macros in MS Excel

So that's how it's done. I've been trying hard to figure out how my co-worker keeps her files well sorted out. She taught me how doing it on excel once but, I've forgotten how she did it. Now all I have to do is enable the macros and start on a new record again. Many thanks Valbuena Jane. I'd treat you for a coffee if I knew you. This site is amazing! Full of intelligent people.

About davidsonriley

Questions
6

Answers
7

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Excel

Answered By acrylos 10 points N/A #91123

Re Use of Macros in MS Excel

Valbuena Jane If I hadn't found this site, I would probably still be waist deep in our accounts that I've been tracking. I have been searching for so long for a solution that would help me in my files. The problem was that I don't know what to ask for my question. Then I found a link to this site, found this question and your answer, did a little browsing about macros and VOILA! You certainly made my day. Thank you! And, congratulations Techyv for having a talent like Valbuena Jane here on your site.

About acrylos

Questions
5

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Excel

Answered By miniangel 10 points N/A #91124

Re Use of Macros in MS Excel

This answer certainly helped me with my accounting problems. Now I don't have to input a new formula again and again on each cell. Good thing there's techyv and techies like Valbuena Jane. More power to techyv.

About miniangel

Questions
5

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Excel

Answered By tymoore 10 points N/A #91125

Re Use of Macros in MS Excel

Hello there!

I just started out a new bakery wherein I have to track all our day's sales and inventory. Now I know how to do basic excel but didn't know the extent of its capabilities. I also used to create files from scratch every day. Well, that won't be the case anymore. I just started using macros and used your answer above for reference and was enlightened. My heartfelt thanks to Valbuena Jane and this wonderful site.

About tymoore

Questions
9

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Excel

Answered By avery 0 points N/A #91126

Re Use of Macros in MS Excel

One answer, so many comments. Definitely a good thread. Let's make it longer by adding mine.

I just got hired and just started using formulas in excel and yes, I am a noob. I am pressured at work on how to get quick inputs that tally automatically. My sister taught me how to use macros but didn't know if I can reuse it again. I browsed and got a link to this question. After reading it, I immediately tried it and it works. Now, what more can I say? Great Answer! Thanks Jane and techyv! Now I know where to look at when I have problems regarding I.T.

About avery

Questions
7

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Excel

Answered By ljones 0 points N/A #91127

Re Use of Macros in MS Excel

This certainly worked for me. Did a little browsing for information about macros too. Learned a lot. Also made my job a lot easier. I even created a shortcut command key for it. Thanks to TECHYV and to the one who answered first.

About ljones

Questions
6

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Excel

Answered By jarris 0 points N/A #91128

Re Use of Macros in MS Excel

I found this a bit frustrating at first but when I learned how to use formulas correctly, it was a breeze. Thanks for your useful tip regarding macros and it's usability.

About jarris

Questions
6

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 03/31/2012
• Question Category: MS Excel

Answered By majellarichards 30 points N/A #91129

Re Use of Macros in MS Excel

So, I see I'm not the only one here who had this kind of problem. Luckily for us we have techyv that is full of intelligent people.

I know now where to go when I have PC problems.

We can almost find every answers we need here. 🙂

About majellarichards

Questions
6

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/02/2012
• Question Category: MS Excel