Date Error

M

Murray N Taylor

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
 
P

Patrick Molloy

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
 
M

Murray Taylor

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
 
P

Patrick Molloy

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
 
G

Guest

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
----------------------------------



.
Click to expand...
 
Top