I recently bought a new computer running 64 bit. Some of my macros that were running on a 32 bit no longer work on the 64 bit. I am getting error's stating "Compile error: Can't find project or Library". Going into the VBA References, it shows me Missing Common Controls 6.0 (SP6)
I have done searches on the internet and most of them refer to Access problems or problems after switching to IE10. I am running IE 11. I even found a link from MS to download the 6.0 Controls, but still have the problem.
One of the VBA code's that is producing the error is:
The word Date in Range("F2") = Format(Date, mmmm, dd, yyyy) is highlighted in Blue. Clicking on the OK button, the Macro name is highlighted Yellow. Clicking on the Reset button the code runs.
I can't figure this out and need some help from you guys.
Thanks.
I have done searches on the internet and most of them refer to Access problems or problems after switching to IE10. I am running IE 11. I even found a link from MS to download the 6.0 Controls, but still have the problem.
One of the VBA code's that is producing the error is:
Code:
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim sht As Worksheet
Dim intResponse As Integer
Dim intResponse2 As Integer
'//Inserts the path in the footer of sheet
With ActiveSheet
.PageSetup.LeftFooter = "&8" & _
ThisWorkbook.FullName
End With
'//Prompts the user for a date if printing the PROPOSAL
If ActiveSheet.Name = ("PROPOSAL") Then
intResponse = MsgBox(Prompt:="INSERT TODAY'S DATE?", _
Buttons:=vbQuestion + vbYesNoCancel, Title:="REMINDER")
Select Case intResponse
Case vbYes
Range("F2") = Format([B]Date[/B], mmmm, dd, yyyy)
Case vbNo
Exit Sub
Case vbCancel
Cancel = True
End Select
End If
End Sub
The word Date in Range("F2") = Format(Date, mmmm, dd, yyyy) is highlighted in Blue. Clicking on the OK button, the Macro name is highlighted Yellow. Clicking on the Reset button the code runs.
I can't figure this out and need some help from you guys.
Thanks.