Program to apply macro to new spreadsheet
 

Sorry, this may be an easy answer, but I dont have it -

Ive got an macro that does some simple manipulation of an excel sheet
- removes header rows, totals, and then sorts the data.

I then use sql to import the data and do a few simple tasks..

The problem is that our excel sheet gets sent to us every day with new
data, and the macro is not part of the sheet. I have to go in and add
the macro myself every day before im import the data.

Is there a simple way (programmatically or other) to quickly have a
macro applied to the spreadsheet and run?

Thanks

Program to apply macro to new spreadsheet
 

Hi,

You can:
1. Put the macro in the Personal Macro Workbook
2. You can run any macro in any open file from any other file
3. You can create a Add-In
4. You may need to generalize your code so it can be run in any of the above
solutions.
--
Cheers,
Shane Devenshire


"miaminemo" wrote:

Sorry, this may be an easy answer, but I dont have it -

Ive got an macro that does some simple manipulation of an excel sheet
- removes header rows, totals, and then sorts the data.

I then use sql to import the data and do a few simple tasks..

The problem is that our excel sheet gets sent to us every day with new
data, and the macro is not part of the sheet. I have to go in and add
the macro myself every day before im import the data.

Is there a simple way (programmatically or other) to quickly have a
macro applied to the spreadsheet and run?

Thanks