Automatically OPENing (GetObject) and Closing EXCEL via VB calls

  • Thread starter Thread starter Brian E McNamee
  • Start date Start date
B

Brian E McNamee

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!
 
Back
Top