PDA

View Full Version : Automation Error



ramkay52
04-16-2015, 12:21 AM
When I try MsgBox Date in VBE Immediate window, or in the code, i get the error message: RunTime Error '-2147483640 (80000008)' Automation Error.
I am using MS Excel for Mac 2011 Version 14.4.8.

But this works fine in Windows.

Use of MonthName function also returns an automation error.

Can anybody help?