Problem with Date in macro

**rbyrd023** · 03-13-2010, 03:48 PM

Hello,

I have a few macros that have a "Date" function in it for example,

Code:

IF Date => Sheets("Example").Range("A1") Then Something Happen

My problem is that some of my end users are having a error upon running that code.

A error box pops up and states that there is a compile error in a hidden module.

I checked in to it on the computers that were having the issue and found the "Date" was the problem.

Any suggestions as to how to fix it?????

**protonLeah** · 03-13-2010, 04:12 PM

Post the complete macro. Be sure to wrap it in code tags (use the "#" on the menu bar.)

**rbyrd023** · 03-13-2010, 08:01 PM

Code:

Sub Insurancejob()
'
' insurancejob Macro
'

'
    If Range("S45") = "yes" Then
    Sheets("Information WS").Select
    ActiveSheet.Unprotect "9151"
    Range("C36").ClearContents
    Range("A1").Value = Date
    Range("F39:N39,F42:N42,F45:N45,F48:N48").Locked = False
    
    ActiveSheet.Protect "9151"

    priceupdater.Show
    Range("F20").Select
    
    Else
    
    Dim pageerror As String
    pageerror = MsgBox("Please Complete This Page", , "Page Error")
    
    
    End If
    
End Sub

Or another one that I have would be

Code:

Dim wks As Worksheet
If Date >= Sheets("Error").Range("P1").Value Then

Sheets("Error").Select
  expiredversion.Show

**broro183** · 03-13-2010, 09:03 PM

Hi,

I could be wrong but I think they may be missing a reference. In the VBE -Tools - References - tick "Visual basic For Applications".

I'm basing this on the fact that if I press [F2] in the VBE to bring up the Object Browser, search for Date, and highlight the relevant row it states

Property Date As Variant
Member of VBA.DateTime

If you then click on the hyperlink of the "VBA" section you are shown

Library VBA
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
Visual Basic For Applications

If you can't tick this option in the References dialog box, it may be "missing", in which case a quick Google search should help you.

hth
Rob

**rbyrd023** · 03-13-2010, 10:25 PM

The reference is there on the computer in which I am doing the programming. Perhaps it is not on the computers that are not. I will check and reply back soon. Thank you!

**rbyrd023** · 03-14-2010, 12:42 PM

OK, all of the computers that are having the problem seem to have the same settings as my own! Now I am really confused! Its not only this macro but popular ones like "SpellNumber" are not working on some computers as well.