Solved

Excel Macros in a workbook that gets generated each month

Posted on 2014-11-12
4
189 Views
Last Modified: 2014-11-12
What's the best way to handle this situation? A user has data that is exported to Excel each month from another system - the data changes each time. He created a macro that he wants to run on the data each month. Is it better to have a shell workbook (blank) containing only the macro and copy/paste the data into this workbook, or is it better to copy/paste the macro into the workbook already containing the data, which will be different each time the report is run? Or is there even a better way to handle this? Just looking for some suggestions. Thanks.
0
Comment
Question by:esu4236
  • 2
  • 2
4 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40437918
Have the macro in a separate workbook - maybe even in your Personal Macro Workbook - and then your data workbook does not need any code at all (if your code is workbook independent).
0
 

Author Comment

by:esu4236
ID: 40437944
I don't want it in my Personal Macro workbook because I may have someone else working on this file as well. So they need to be able to get to the macro.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40437947
Therefore, have it in a separate workbook.

Have it open when you want to run the macro.

Then run the macro from your data workbook.
0
 

Author Closing Comment

by:esu4236
ID: 40437992
Makes sense. Thanks.
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question