Thread: Error 458
View Single Post
  #4   Report Post  
Bill Manville
 
Posts: n/a
Default


I guess this is a VB application, not VBA within Excel?
I assume you have referenced the Excel object library

After Windows("FileA.xls").Activate

I assume you mean xlApp.Windows("FileA.xls").Activate
and xlApp.ActiveWorkbook.Save

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