I have a macro enabled file on my laptop, copied the same on to a Desktop; both of them have ODBC installed.
When I refresh the workbook on my Laptop it works, however, it fails on the Desktop giving me a ODBC error 1004.
Any help would be greatly appreciated.
Below is the code I used:
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Dim mCOUNTER As String
mCOUNTER = 0
If mCOUNTER > 0 Then
mCOUNTER = 1
Application.OnTime Now + TimeValue("00:00:05"), "TexttocolumnChat"
' Application.OnTime Now + TimeValue("00:00:14"), "agentdata"
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
message edited by Mohannew