cnmcc
asked on
ERROR 432 - FIle name or class name not found during Automation operation
I am getting this error when I try to create an Excel spreadsheet through VBA. The code is:
Set wbXL = GetObject("file.xls")
This had been working in the past but I have been getting this error ever since one of the individuals installed Access 2007 on the computer although they didn't open this database in 2007(??)
Any ideas what may be causing this problem?
Set wbXL = GetObject("file.xls")
This had been working in the past but I have been getting this error ever since one of the individuals installed Access 2007 on the computer although they didn't open this database in 2007(??)
Any ideas what may be causing this problem?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER