Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
8 Functions in a spreadsheet program | Excel Discussion (Misc queries) | |||
automatically apply a macro to all worksheets | Excel Discussion (Misc queries) | |||
Can you open a new spreadsheet in a new program window? | Excel Discussion (Misc queries) | |||
Need Help Initializing Excel Spreadsheet Program | Excel Discussion (Misc queries) | |||
Need Help Initializing Excel Spreadsheet Program | Excel Discussion (Misc queries) |