VBA date - compile error

[Dawnali]

Hi all, I'm using code below in a macro to show a popup box if the date is not equal to today. (date in cell g2 of the excel file)

Works on my computer, but for one friends, when he tries to run it, he got an error message "Compile error: Can't find project or library" pointing to Date.

Can someone help on this ?

Please Login or Register  to view this content.

[teylyn]

Hi Dawnali,

welcome to the forum.

In the VBE, click Tools - References and make sure that at least the following libraries are selected/ticked

Visual Basic for Applications
Microsoft Excel 12.0 Object Library
Microsoft Office 12.0 Object Library
OLE Automation

Then run the code again.

hth

[Dawnali]

Hi teylyn,

thanks for your reply. I checked this, all the mentioned libraries are ticked, plus another one called "MISSING: Microsoft Windows Common Controls-2 6.0".
However, the code still does not work.

Note if it can help, the system did not recognise the Chr(13) either, when I replaced it with vbNewLine, that was fine.

Would there be something else than "Date" that I can use ?
or anyother proposal ?

Thanks for your help !

[Andy Pope]

You need to resolve the missing library problem first.

You could just try unchecking it. But if you have code that referenced the library you will still get errors.

[Dawnali]

Thanks for your advice. I corrected 2 things (which both solved that issue, even when taken separate).

solution 1 : replace the mention "Date" by "VBA.DateTime.Date"
solution 2 : downloaded and installed component MSCOMCT2.OCX (not provided with Excel 2007)

In case this might be usefull to anyone, here is the link where I downloaded this (in french sorry) http://excel.developpez.com/outils/?...roles#MSCOMCT2

Thanks all !