Automatically OPENing (GetObject) and Closing EXCEL via VB calls

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing VB triggers closing Excel 2
VB reformats dates when opening .CSV in excel 2
question about opening SQL results in Excel from ASP.NET via XML 2
automatically copy image from excel and paste in powerpoint in VB 2
Controlling Notepad from excel ( VB programming) 1
Excel Excel VB - exporting & importing data 0
Problem with Excel 2003 files and blue worksheet icons in VB Edito 4
Form Navigation Via Show() or ShowDialog() 1

Top