Hi Bill,

In the Form_Load event,
After Dim xlApp As Object
Dim xlBook As Excel.Workbook
Set xlApp = CreateObject("Excel.Application")

The statement: Set xlBook = xlApp.Workbooks.Open("C:\Program Files\ProjectA\
FileA.xls")
causes the error.

In another event,
After Windows("FileA.xls").Activate

The statement: ActiveWorkbook.Save
causes the error.

Regards,
Bob Mignault


"Bill Manville" wrote in message
...
Bob Mignault wrote:
I keep getting the message: "Run-time error 458:
Variable uses an Automation type not supported in Visual Basic".


On what VB statement does this occur?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup