Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open vs. macro
Jim,
The Auto_Open won't run when a workbook is opened via code. If you place your code in the Workbook_Open Event, that will fire whenever the workbook opens either manually or via code. You can "run" your Auto_Open macro with the following: ActiveWorkbook.RunAutoMacros xlAutoOpen Either way thjough, I believe the Workbook_Open event or calling the Auto_Open will occur before the paste operation (which won't do you any good). A better choice would be to open the second workbook and manipulate it via the coding in the first workbook (after the paste operation). John Jim Melchers wrote: I am trying to have a macro copy data from 1 worksheet and paste it into another and then want to automatically execute a macro in the second which formats, prints, and closes. Auto_Open doesn't seem to run after the paste completes. The path to the second file is stored in a cell in the first, can I use that somehow to establish a reference to the macro in the second? Any other suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bypass Auto_open Macro in Excel 2007 | Excel Discussion (Misc queries) | |||
Minimising the Ribbon in an Auto_Open macro | Excel Discussion (Misc queries) | |||
Auto_Open Macro | Excel Discussion (Misc queries) | |||
Can I make an Auto_open macro conditional? | Excel Discussion (Misc queries) | |||
Force read-only in auto_open macro | Excel Discussion (Misc queries) |