Thanks Dean,
At the moment, I don't even care about the prompt. All I am looking to do is
open a workbook and close it again, without leaving an Excel footprint in
the task-manager.
Again, all help is appreciated.
Paul
"Dean Hinson" schreef in bericht
...
Paul,
I do not use VB itself, but using VBA within the workbook, I use
Application.Quit. Then in the Workbook_Close(), I use
Application.DisplayAlerts = False. Maybe you might need to place some VBA
in
your workbook that you are opening in the VB script to totally close
Excel.
However, to make it open/close without any prompting I use a digital
signature in the VBA so that when the workbook opens, it does not prompt
regarding macro security.
Just a thought.
Dean.
"Paul van Kan" wrote:
Hi All,
I have read a lot about problems with getting Excel to quit from
VBScript,
but none of the suggestions seem to work for me. I am using VBScript 5.6
and
Excel 2002 SP3.
It doesn't get much simpler than this:
Sub Main()
Dim oExcel
Dim oWorkBook
Set oExcel = CreateObject("Excel.Application")
Set oWorkBook = oExcel.WorkBooks.Open("C:\TEST.XLS")
oWorkBook.Close False
Set oWorkBook = Nothing
oExcel.Quit
Set oExcel = Nothing
End Sub
Still, Excel is remaining active in the task-manager after running this
snippet. Leaving out the workbook-stuff (just starting and closing Excel)
works fine, but as soon as I start using an actual workbook, Excel won't
quit.
Does anybody have any ideas on how to solve this?
Thanks,
Paul