What different reasons are there for getting the following error message:

Run-time error '1004':

The macro 'filename!macroname' cannot be found.


I'm certain the file is present and open, and that the file contains the
macro that is being run.

A syntax error leading to a compile error does not seem to be the culprit.

This is a case where one addin is trying to run a macro in another addin by
way of an Application.Run statement.

Thanks,

Brian Murphy

It could be a private sub.

It may not be in a standard code module.

It may be in an other workbook.

By your last statement,did you include the addin name in the run statement?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Brian Murphy" wrote in message
...
What different reasons are there for getting the following error message:

Run-time error '1004':

The macro 'filename!macroname' cannot be found.


I'm certain the file is present and open, and that the file contains the
macro that is being run.

A syntax error leading to a compile error does not seem to be the culprit.

This is a case where one addin is trying to run a macro in another addin
by
way of an Application.Run statement.

Thanks,

Brian Murphy

Thanks for the reply, Bob.

These are macros that I've been using for years. Now all of the
sudden two customers are getting the "compile error in hidden module"
messages in a new file I recently sent them. The file checks out fine
for me with excel 97, 2000, 2002 and 2003. So I'm baffled.

Brian


I don't have any idea what the problem could be. I send the offending
file

"Bob Phillips" wrote in message ...
It could be a private sub.

It may not be in a standard code module.

It may be in an other workbook.

By your last statement,did you include the addin name in the run statement?

--

HTH

Bob Phillips

Brian,

The error has changed from an can't find macro error to error in hidden
module.

Did you write the addin, or is it a commercial one? Can you open the addin
up and find the spot it errors?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Brian Murphy" wrote in message
om...
Thanks for the reply, Bob.

These are macros that I've been using for years. Now all of the
sudden two customers are getting the "compile error in hidden module"
messages in a new file I recently sent them. The file checks out fine
for me with excel 97, 2000, 2002 and 2003. So I'm baffled.

Brian


I don't have any idea what the problem could be. I send the offending
file

"Bob Phillips" wrote in message
...
It could be a private sub.

It may not be in a standard code module.

It may be in an other workbook.

By your last statement,did you include the addin name in the run
statement?

--

HTH

Bob Phillips

The compile error is something that led to the macro not found problem.

Here's the story.

The addins, there are two involved, are my own. I've been distributing these for years (www.xlrotor.com).
Addin1 is the primary addin.
Addin2 is secondary.
Addin2 is opened by Addin1 as needed,
and Addin1 uses Application.Run to run routines in Addin2.
Addin2 has a "reference" set to Addin1 so it can freely call routines in Addin1.
Both addins are "locked for viewing" and passworded, this done with excel 2002.
So far, so good.
I've been doing it this way for years.

I recently made some minor edits in Addin2, and have sent this to 4 customers. Two of the customers have reported "compile error in hidden module: module_name". Although they named different modules. I had fully compiled and saved the addin before sending it to them. I tested the addin with excel97, 2000, 2002 and 2003, with no problems.

I sent a version of Addin2 that is not locked or passworded to one customer, and now he gets the "macro not found" message when Addin1 tries to run a macro in Addin2. He's using Excel 2003. The .Run command doesn't get executed without my Addin1 first making sure Addin2 is open.

I have no clue as to what the problem might be. I cannot reproduce them.

It would be nice to know how they can get a "compile error" when I send it to them fully compiled. Since that is what started all this.

Brian





"Bob Phillips" wrote in message ...
Brian,

The error has changed from an can't find macro error to error in hidden
module.

Did you write the addin, or is it a commercial one? Can you open the addin
up and find the spot it errors?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Brian Murphy" wrote in message
om...
Thanks for the reply, Bob.

These are macros that I've been using for years. Now all of the
sudden two customers are getting the "compile error in hidden module"
messages in a new file I recently sent them. The file checks out fine
for me with excel 97, 2000, 2002 and 2003. So I'm baffled.

Brian


I don't have any idea what the problem could be. I send the offending
file

"Bob Phillips" wrote in message
...
It could be a private sub.

It may not be in a standard code module.

It may be in an other workbook.

By your last statement,did you include the addin name in the run
statement?

--

HTH

Bob Phillips

Well that is as expected, so the code must have an error on some other
system.

Post the code that errors.

Which systems throw errors?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Brian Murphy" wrote in message
...
The compile error is something that led to the macro not found problem.

Here's the story.

The addins, there are two involved, are my own. I've been distributing
these for years (www.xlrotor.com).
Addin1 is the primary addin.
Addin2 is secondary.
Addin2 is opened by Addin1 as needed,
and Addin1 uses Application.Run to run routines in Addin2.
Addin2 has a "reference" set to Addin1 so it can freely call routines in
Addin1.
Both addins are "locked for viewing" and passworded, this done with excel
2002.
So far, so good.
I've been doing it this way for years.

I recently made some minor edits in Addin2, and have sent this to 4
customers. Two of the customers have reported "compile error in hidden
module: module_name". Although they named different modules. I had fully
compiled and saved the addin before sending it to them. I tested the addin
with excel97, 2000, 2002 and 2003, with no problems.

I sent a version of Addin2 that is not locked or passworded to one customer,
and now he gets the "macro not found" message when Addin1 tries to run a
macro in Addin2. He's using Excel 2003. The .Run command doesn't get
executed without my Addin1 first making sure Addin2 is open.

I have no clue as to what the problem might be. I cannot reproduce them.

It would be nice to know how they can get a "compile error" when I send it
to them fully compiled. Since that is what started all this.

Brian





"Bob Phillips" wrote in message
...
Brian,

The error has changed from an can't find macro error to error in hidden
module.

Did you write the addin, or is it a commercial one? Can you open the addin
up and find the spot it errors?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Brian Murphy" wrote in message
om...
Thanks for the reply, Bob.

These are macros that I've been using for years. Now all of the
sudden two customers are getting the "compile error in hidden module"
messages in a new file I recently sent them. The file checks out fine
for me with excel 97, 2000, 2002 and 2003. So I'm baffled.

Brian


I don't have any idea what the problem could be. I send the offending
file

"Bob Phillips" wrote in message
...
It could be a private sub.

It may not be in a standard code module.

It may be in an other workbook.

By your last statement,did you include the addin name in the run
statement?

--

HTH

Bob Phillips