having a bad hair day with a VBA call, I use the code

tmpdate = Date

this is run as part of an Auto_Open() proc in a
module "Main" in a workbook, the code is protected.

This works fine on some systems, but one others I get an
error message:

Cannot create object in hidden module Main

I know I have been and cured this before but I cannot for
the life of me remember how it's done.

Murray

this is often a misleading error which occurs when a
reference is missing. stop any code , then under
Tools/references chech if anything is missing. If there
is. then you'll need to re-point to the dll or ocx or
whatever.

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
having a bad hair day with a VBA call, I use the code

tmpdate = Date

this is run as part of an Auto_Open() proc in a
module "Main" in a workbook, the code is protected.

This works fine on some systems, but one others I get an
error message:

Cannot create object in hidden module Main

I know I have been and cured this before but I cannot
for
the life of me remember how it's done.

Murray

.

Just the ticket, thanks, as a matter of idle interest how
can I work out what is missing on the systems causing
problems, is it simply registering the relevant DLL?

Murray

-----Original Message-----
this is often a misleading error which occurs when a
reference is missing. stop any code , then under
Tools/references chech if anything is missing. If there
is. then you'll need to re-point to the dll or ocx or
whatever.

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
having a bad hair day with a VBA call, I use the code

tmpdate = Date

this is run as part of an Auto_Open() proc in a
module "Main" in a workbook, the code is protected.

This works fine on some systems, but one others I get an
error message:

Cannot create object in hidden module Main

I know I have been and cured this before but I cannot
for
the life of me remember how it's done.

Murray

.

.

yes it is.
We use a custom installer that out IT uses for every "build" that ensures
all our users have the right dll's etc

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"Murray Taylor" wrote in message
...
Just the ticket, thanks, as a matter of idle interest how
can I work out what is missing on the systems causing
problems, is it simply registering the relevant DLL?

Murray

-----Original Message-----
this is often a misleading error which occurs when a
reference is missing. stop any code , then under
Tools/references chech if anything is missing. If there
is. then you'll need to re-point to the dll or ocx or
whatever.

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
having a bad hair day with a VBA call, I use the code

tmpdate = Date

this is run as part of an Auto_Open() proc in a
module "Main" in a workbook, the code is protected.

This works fine on some systems, but one others I get an
error message:

Cannot create object in hidden module Main

I know I have been and cured this before but I cannot
for
the life of me remember how it's done.

Murray

.

.

Many thanks.

Murray

-----Original Message-----
yes it is.
We use a custom installer that out IT uses for
every "build" that ensures
all our users have the right dll's etc

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"Murray Taylor"
wrote in message
...
Just the ticket, thanks, as a matter of idle interest
how
can I work out what is missing on the systems causing
problems, is it simply registering the relevant DLL?

Murray

-----Original Message-----
this is often a misleading error which occurs when a
reference is missing. stop any code , then under
Tools/references chech if anything is missing. If there
is. then you'll need to re-point to the dll or ocx or
whatever.

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
having a bad hair day with a VBA call, I use the code

tmpdate = Date

this is run as part of an Auto_Open() proc in a
module "Main" in a workbook, the code is protected.

This works fine on some systems, but one others I get
an
error message:

Cannot create object in hidden module Main

I know I have been and cured this before but I cannot
for
the life of me remember how it's done.

Murray

.

.



.