VBA "Date" not working

[jameshunt83]

I have a workbook with a macro with the below line on it.

Sub converttoenquiry()
If Range("V2").Value = "" Then Range("V2").Value = Date
End Sub

This worked fine previously however I have just copied the file to another computer and it doesn't seem to like the "Date" part of it. Why is this and how do I fix it?

 

[JamesW]

Hi,

What error do you get?

 

[jameshunt83]

It says "compile error: Can't find project or library"

 

[JamesW]

Try this:

Press ALT+F11 to open the Visual Basic Editor.
Click Tools -> References
Clear the check box for the type library or object library marked as "Missing:"

 

[jameshunt83]

Brilliant. that did the trick. thanks for your help

 

[Ten98]

This is a great fix, and works for me too, the problem is with the "Microsoft Excel 12.0 Object Library".

However, is there any way for me to stop this error happening? I would rather not have to ask my users to go into the VBA editor and uncheck libraries... This, to them, is like computer hacking and rocket science

I use Excel 2007 and most of my colleagues use Excel 2003. I don't use any of the features specific to 12.0, as I need my macros to work on Excel 2003.

Is there some way I can force my Excel 2007 to use the 11.0 object library instead of the 12.0, and stop this problem ??