K
kmbarz
Since my high powered data analysis programming language doesn't seem to want
to play nice with Excel (where I want the data to go) I'm having to resort to
using a vbscript to act as a bridge between the two. In this script, after
the macro runs I want Excel to close down and not save. However, when it
closes it prompts me on whether I want to save or not. Is there a way to
have Excel not put up the prompt and close without saving? Thanks
Option Explicit
Dim objXL
Set objXL = WScript.CreateObject("Excel.Application")
objXL.WorkBooks.Open "\\Inmrc\irs\temp\Reports.xls"
objXL.Visible = TRUE ' Optional
objXL.Run("LoadData")
objXL.Quit
Set objXL = Nothing
to play nice with Excel (where I want the data to go) I'm having to resort to
using a vbscript to act as a bridge between the two. In this script, after
the macro runs I want Excel to close down and not save. However, when it
closes it prompts me on whether I want to save or not. Is there a way to
have Excel not put up the prompt and close without saving? Thanks
Option Explicit
Dim objXL
Set objXL = WScript.CreateObject("Excel.Application")
objXL.WorkBooks.Open "\\Inmrc\irs\temp\Reports.xls"
objXL.Visible = TRUE ' Optional
objXL.Run("LoadData")
objXL.Quit
Set objXL = Nothing