Solved

Excel Macros in a workbook that gets generated each month

Posted on 2014-11-12
4
184 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
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…

861 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now