Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
execute a macro
I've exported the results of a parametric query in an excel file (I've setup
the file and the spreadsheet) Then I've built a macro that replace some words with others..then I've built a pivot table and I've copied and paste it on another excel file .Of course the above macro can't be attached to the excel file because it changes everytime I update the query so it deletes itself .So I've had the idea of export the results of the query in the excel file then close it and put the macro I've built on the third excel file.. is it possible to execute a macro on a file that it's closed ?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
execute a macro
No. But you have a workbook that automatically opens when Excel opens,
Personal.xls, and it stays hidden so it doesn't get in the way. Go to ToolMacroRecord New Macro, and select Personal Macro Workbook from the dropdown in the dialog, then OK. Immediately click the Stop button, and you will have a Personal.xls. You can copy your macro into there. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Rossy" wrote in message ... I've exported the results of a parametric query in an excel file (I've setup the file and the spreadsheet) Then I've built a macro that replace some words with others..then I've built a pivot table and I've copied and paste it on another excel file .Of course the above macro can't be attached to the excel file because it changes everytime I update the query so it deletes itself .So I've had the idea of export the results of the query in the excel file then close it and put the macro I've built on the third excel file.. is it possible to execute a macro on a file that it's closed ?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
execute a macro
I know that but I'd like it to work on every pc
"Bob Phillips" wrote: No. But you have a workbook that automatically opens when Excel opens, Personal.xls, and it stays hidden so it doesn't get in the way. Go to ToolMacroRecord New Macro, and select Personal Macro Workbook from the dropdown in the dialog, then OK. Immediately click the Stop button, and you will have a Personal.xls. You can copy your macro into there. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Rossy" wrote in message ... I've exported the results of a parametric query in an excel file (I've setup the file and the spreadsheet) Then I've built a macro that replace some words with others..then I've built a pivot table and I've copied and paste it on another excel file .Of course the above macro can't be attached to the excel file because it changes everytime I update the query so it deletes itself .So I've had the idea of export the results of the query in the excel file then close it and put the macro I've built on the third excel file.. is it possible to execute a macro on a file that it's closed ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-execute macro.... | Excel Discussion (Misc queries) | |||
execute macro in other workbook | Excel Programming | |||
Execute Macro | Excel Discussion (Misc queries) | |||
force a macro to execute | Excel Programming | |||
Automatically execute a macro | Excel Programming |