Prev: How to move worksheet into specific position?
Next: Protected project visible
From: xp on 27 May 2010 17:02
Try:

To your Excel object append: Application.DisplayAlerts = False

Also, to close without a message, save first then use:
oWorkbook.Close SaveChanges:=False

HTH

"Brian E McNamee" wrote:

> What is the calling sequence from VB to "Set gobjEXCELWorkBook =
> GetObject(pzExcelFileName)" and "gobjEXCELWorkBook.Close" an EXCEL
> Application witout having to answer dialogs about "Different Format" or "Save
> Changes". This consumes a lot of time and repetitiveness when you're going
> through 50 - 100 worbooks!
> --
> Brian McNamee
 | 
Pages: 1
Prev: How to move worksheet into specific position?
Next: Protected project visible