Link to home
Start Free TrialLog in
Avatar of cnmcc
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?
ASKER CERTIFIED SOLUTION
Avatar of 60MXG
60MXG

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cnmcc
cnmcc

ASKER

Thank you for your help. This worked fine.