Date Error

  • Thread starter Thread starter Murray N Taylor
  • Start date Start date
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
 
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
 
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
 
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
 
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...
 
Back
Top