TIME function used in Excel

  • Thread starter Thread starter jeramy
  • Start date Start date
J

jeramy

I'm new to these newsgroups, so I apologize if my etiquette is not
appropriate.

I'm trying to help a friend whose computer was recently replaced. In his
new computer, his custom macro will not run. He gets a "Microsoft Visutal
Basic Compile error: Can't find project or library" with the TIME function
highlighted.

I first suggested using the NOW or DATE function, but he said it creates an
additional series of errors.

I also tried installing 'Windows Script 5.6' to no avail. Any suggestions
on how to get this TIME function to work?

Thank you in advance for any response.

Jeramy
 
Hi Jeramy,

In the VBE, go to References on the Tools menu; look for any references
marked MISSING and try to delete them. If the missing references are needed,
hit the Browse button to locate them.
 
Thank you so much for the fast response, Norman. I looked in the Visual
Basic Editor, but References is grey in the Tools menu (not available). I'm
not a VB developer, so I'm not familiar with it or it's IDE, but Help
suggests the same action. What can I do to make the References option
available?


Hi Jeramy,

In the VBE, go to References on the Tools menu; look for any references
marked MISSING and try to delete them. If the missing references are needed,
hit the Browse button to locate them.
 
Hi Jeramy,

Its probably greyed out as you are in the debug mode. Stop the debug first
and then again go to the tools > References and follow Norman's advice.

Mangesh
 
Hi Jeramy,

And to add to Mangesh's suggestion - in case you are unfamiliar - to leave
debug mode , on the VBE menu, select Run | Reset.
 
Thank you both very much. I am now hunting the missing ocx file to see if
it fixes the problem.



Hi Jeramy,

Its probably greyed out as you are in the debug mode. Stop the debug first
and then again go to the tools > References and follow Norman's advice.

Mangesh
 
It works :) thank you both very much

Hi Jeramy,

And to add to Mangesh's suggestion - in case you are unfamiliar - to leave
debug mode , on the VBE menu, select Run | Reset.
 
Back
Top