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

xp,

That did the trick! Thank you. I'll spend the time saved wisely,
--
Brian McNamee


"xp" wrote:

> 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