How do I run a sub that is declared as public in a different open workbook
(project)?

Thanks,

Antonio

dim otherworkbook as workbook

set otherworkbook = workbooks("yourothernamehere.xls")

application.run "'" & otherworkbook.name & "'!macronamehere"



Antonio wrote:

How do I run a sub that is declared as public in a different open workbook
(project)?

Thanks,

Antonio

--

Dave Peterson

try
application.run otherworkbook.xls!mymacro

--
Don Guillett
SalesAid Software

"Antonio" wrote in message
...
How do I run a sub that is declared as public in a different open
workbook
(project)?

Thanks,

Antonio

I have used

I get:

Run-time error '1004':

The macro 'myworkbook.xls!kill_max_min' cannot be found.

In myworkbook I have

Public Sub kill_max_min()

Application.OnTime runwhen, "max_min", , False

End Sub


What am I doing wrong?

Thanks,

Antonio

"Don Guillett" wrote:

try
application.run otherworkbook.xls!mymacro

--
Don Guillett
SalesAid Software

"Antonio" wrote in message
...
How do I run a sub that is declared as public in a different open
workbook
(project)?

Thanks,

Antonio

What did you use?

Antonio wrote:

I have used

I get:

Run-time error '1004':

The macro 'myworkbook.xls!kill_max_min' cannot be found.

In myworkbook I have

Public Sub kill_max_min()

Application.OnTime runwhen, "max_min", , False

End Sub

What am I doing wrong?

Thanks,

Antonio

"Don Guillett" wrote:

try
application.run otherworkbook.xls!mymacro

--
Don Guillett
SalesAid Software

"Antonio" wrote in message
...
How do I run a sub that is declared as public in a different open
workbook
(project)?

Thanks,

Antonio




--

Dave Peterson

Sorry, I have used

Application.Run "myworkbook.xls!kill_max_min"

I have also tried


Dim otherworkbook As Workbook
Set otherworkbook = Workbooks("myworkbook.xls")
Application.Run "'" & otherworkbook.Name & "!kill_max_min"

The run method does seem to pint to myworkbook.xls but cannot find the sub

"Dave Peterson" wrote:

What did you use?

Antonio wrote:

I have used

I get:

Run-time error '1004':

The macro 'myworkbook.xls!kill_max_min' cannot be found.

In myworkbook I have

Public Sub kill_max_min()

Application.OnTime runwhen, "max_min", , False

End Sub

What am I doing wrong?

Thanks,

Antonio

"Don Guillett" wrote:

try
application.run otherworkbook.xls!mymacro

--
Don Guillett
SalesAid Software

"Antonio" wrote in message
...
How do I run a sub that is declared as public in a different open
workbook
(project)?

Thanks,

Antonio




--

Dave Peterson

You dropped a single quote from this attempt:
Application.Run "'" & otherworkbook.Name & "'!kill_max_min"

But I don't think that's the problem.

Both versions (after correction) worked ok for me.

Is Kill_max_min in a general module?



Antonio wrote:

Sorry, I have used

Application.Run "myworkbook.xls!kill_max_min"

I have also tried


Dim otherworkbook As Workbook
Set otherworkbook = Workbooks("myworkbook.xls")
Application.Run "'" & otherworkbook.Name & "!kill_max_min"

The run method does seem to pint to myworkbook.xls but cannot find the sub

"Dave Peterson" wrote:

What did you use?

Antonio wrote:

I have used

I get:

Run-time error '1004':

The macro 'myworkbook.xls!kill_max_min' cannot be found.

In myworkbook I have

Public Sub kill_max_min()

Application.OnTime runwhen, "max_min", , False

End Sub

What am I doing wrong?

Thanks,

Antonio

"Don Guillett" wrote:

try
application.run otherworkbook.xls!mymacro

--
Don Guillett
SalesAid Software

"Antonio" wrote in message
...
How do I run a sub that is declared as public in a different open
workbook
(project)?

Thanks,

Antonio




--

Dave Peterson


--

Dave Peterson

Is it possible that you did not use YOUR workbook name?

--
Don Guillett
SalesAid Software

"Dave Peterson" wrote in message
...
You dropped a single quote from this attempt:
Application.Run "'" & otherworkbook.Name & "'!kill_max_min"

But I don't think that's the problem.

Both versions (after correction) worked ok for me.

Is Kill_max_min in a general module?



Antonio wrote:

Sorry, I have used

Application.Run "myworkbook.xls!kill_max_min"

I have also tried


Dim otherworkbook As Workbook
Set otherworkbook = Workbooks("myworkbook.xls")
Application.Run "'" & otherworkbook.Name & "!kill_max_min"

The run method does seem to pint to myworkbook.xls but cannot find the
sub

"Dave Peterson" wrote:

What did you use?

Antonio wrote:

I have used

I get:

Run-time error '1004':

The macro 'myworkbook.xls!kill_max_min' cannot be found.

In myworkbook I have

Public Sub kill_max_min()

Application.OnTime runwhen, "max_min", , False

End Sub

What am I doing wrong?

Thanks,

Antonio

"Don Guillett" wrote:

try
application.run otherworkbook.xls!mymacro

--
Don Guillett
SalesAid Software

"Antonio" wrote in message
...
How do I run a sub that is declared as public in a different
open
workbook
(project)?

Thanks,

Antonio




--

Dave Peterson


--

Dave Peterson

Just to cover all the bases, is the workbook containing the macro
open? It must be.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Antonio" wrote in message
...
Sorry, I have used

Application.Run "myworkbook.xls!kill_max_min"

I have also tried


Dim otherworkbook As Workbook
Set otherworkbook = Workbooks("myworkbook.xls")
Application.Run "'" & otherworkbook.Name & "!kill_max_min"

The run method does seem to pint to myworkbook.xls but cannot
find the sub

"Dave Peterson" wrote:

What did you use?

Antonio wrote:

I have used

I get:

Run-time error '1004':

The macro 'myworkbook.xls!kill_max_min' cannot be found.

In myworkbook I have

Public Sub kill_max_min()

Application.OnTime runwhen, "max_min", , False

End Sub

What am I doing wrong?

Thanks,

Antonio

"Don Guillett" wrote:

try
application.run otherworkbook.xls!mymacro

--
Don Guillett
SalesAid Software

"Antonio" wrote in
message
...
How do I run a sub that is declared as public in a
different open
workbook
(project)?

Thanks,

Antonio




--

Dave Peterson