Prev: Print sheets based on cell value
Next: Indirectly referring to a variable
From: Brian E McNamee on 28 May 2010 11:09
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
 | 
Pages: 1
Prev: Print sheets based on cell value
Next: Indirectly referring to a variable