Solved

Excel Macros in a workbook that gets generated each month

Posted on 2014-11-12
4
180 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Makes sense. Thanks.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
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…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

771 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

8 Experts available now in Live!

Get 1:1 Help Now