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

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

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

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

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

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

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