Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlAutoOpen - doesn't work?
I have a macro that opens another workbook and adds data to it, before the data is added a macro in the destination workbook needs to be run so that columns, etc can be added for a new month. I renamed the macro (destination workbook) Auto_Open and tried calling it in the source macro by Workbooks.Open (filePath) Workbooks(fileName).Activate ActiveWorkbook.RunAutoMacros Which:=xlAutoOpen but it never actually runs the macro in the destination workbook called Auto_Open, an ideas? Thanks in advance. -- br_turnbull ------------------------------------------------------------------------ br_turnbull's Profile: http://www.excelforum.com/member.php...o&userid=27479 View this thread: http://www.excelforum.com/showthread...hreadid=478739 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlAutoOpen - doesn't work?
Try
Workbooks.Open "FilePath&Name" ActiveWorkbook.RunAutoMacros xlAutoOpen "br_turnbull" wrote: I have a macro that opens another workbook and adds data to it, before the data is added a macro in the destination workbook needs to be run so that columns, etc can be added for a new month. I renamed the macro (destination workbook) Auto_Open and tried calling it in the source macro by Workbooks.Open (filePath) Workbooks(fileName).Activate ActiveWorkbook.RunAutoMacros Which:=xlAutoOpen but it never actually runs the macro in the destination workbook called Auto_Open, an ideas? Thanks in advance. -- br_turnbull ------------------------------------------------------------------------ br_turnbull's Profile: http://www.excelforum.com/member.php...o&userid=27479 View this thread: http://www.excelforum.com/showthread...hreadid=478739 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlAutoOpen - doesn't work?
Some obvious thoughts perhaps.
Auto_Open is in a standard code module? You open a workbook, and activate one. They use different variables, so I am assuming fileName is a subset of filePath. Is this correct? If not, are you activating the correct workbook? If it is, you don't need the activate, the open activates it. -- HTH RP (remove nothere from the email address if mailing direct) "br_turnbull" wrote in message ... I have a macro that opens another workbook and adds data to it, before the data is added a macro in the destination workbook needs to be run so that columns, etc can be added for a new month. I renamed the macro (destination workbook) Auto_Open and tried calling it in the source macro by Workbooks.Open (filePath) Workbooks(fileName).Activate ActiveWorkbook.RunAutoMacros Which:=xlAutoOpen but it never actually runs the macro in the destination workbook called Auto_Open, an ideas? Thanks in advance. -- br_turnbull ------------------------------------------------------------------------ br_turnbull's Profile: http://www.excelforum.com/member.php...o&userid=27479 View this thread: http://www.excelforum.com/showthread...hreadid=478739 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlAutoOpen - doesn't work?
How are you invoking that macro that opens that other workbook?
If you're using a shortcut key and that shortcut key includes the Shift key, then drop the shift from the shortcut key combination. Holding the shift down when opening a workbook tells excel not to run the auto_open/workbook_open code. It can also confuse excel enough so that it stops when you think it shouldn't. br_turnbull wrote: I have a macro that opens another workbook and adds data to it, before the data is added a macro in the destination workbook needs to be run so that columns, etc can be added for a new month. I renamed the macro (destination workbook) Auto_Open and tried calling it in the source macro by Workbooks.Open (filePath) Workbooks(fileName).Activate ActiveWorkbook.RunAutoMacros Which:=xlAutoOpen but it never actually runs the macro in the destination workbook called Auto_Open, an ideas? Thanks in advance. -- br_turnbull ------------------------------------------------------------------------ br_turnbull's Profile: http://www.excelforum.com/member.php...o&userid=27479 View this thread: http://www.excelforum.com/showthread...hreadid=478739 -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlAutoOpen - doesn't work?
yes filename is a subset of filepath i.e. filepath = C:\File\workbook.xls filename = workbook.xls But i have found a workaround using ThisWorkbook.Workbook_Open() run the macro when the workbook isn't opened manually. Any ideas how could mke this conditional, i.e. somehow i could pass it a value an depending on the value wether it would run or not? the value would hav to be passed from the source macro -- br_turnbul ----------------------------------------------------------------------- br_turnbull's Profile: http://www.excelforum.com/member.php...fo&userid=2747 View this thread: http://www.excelforum.com/showthread.php?threadid=47873 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlAutoOpen - doesn't work?
RunAutoMacros won't run unless you tell it to run.
Workbook_open will run unless you tell it not to: application.enableevents = false 'open your workbook application.enableevents = true with .enableevents = false, then the workbook_open event won't fire. br_turnbull wrote: yes filename is a subset of filepath i.e. filepath = C:\File\workbook.xls filename = workbook.xls But i have found a workaround using ThisWorkbook.Workbook_Open() runs the macro when the workbook isn't opened manually. Any ideas how i could mke this conditional, i.e. somehow i could pass it a value and depending on the value wether it would run or not? the value would have to be passed from the source macro. -- br_turnbull ------------------------------------------------------------------------ br_turnbull's Profile: http://www.excelforum.com/member.php...o&userid=27479 View this thread: http://www.excelforum.com/showthread...hreadid=478739 -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlAutoOpen - doesn't work?
RunAutoMacros won't run unless you tell it to run.
should have been stated as: Auto_open won't run unless you tell it to run using RunAutoMacros. Dave Peterson wrote: RunAutoMacros won't run unless you tell it to run. Workbook_open will run unless you tell it not to: application.enableevents = false 'open your workbook application.enableevents = true with .enableevents = false, then the workbook_open event won't fire. br_turnbull wrote: yes filename is a subset of filepath i.e. filepath = C:\File\workbook.xls filename = workbook.xls But i have found a workaround using ThisWorkbook.Workbook_Open() runs the macro when the workbook isn't opened manually. Any ideas how i could mke this conditional, i.e. somehow i could pass it a value and depending on the value wether it would run or not? the value would have to be passed from the source macro. -- br_turnbull ------------------------------------------------------------------------ br_turnbull's Profile: http://www.excelforum.com/member.php...o&userid=27479 View this thread: http://www.excelforum.com/showthread...hreadid=478739 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to update a column in a work based on another work sheet | New Users to Excel | |||
how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
xlAutoOpen and GetActiveObject | Excel Programming |