Save an excel file in vbscript without user prompt  
Author Message
JMWZona





PostPosted: Wed Jan 18 09:39:09 CST 2006 Top

Excel Programming >> Save an excel file in vbscript without user prompt

Hi, I am trying to edit an excel spreadsheet and then close it using
vbscript.

the script currently edits the data fine, but when it closes, it gives
the Save prompt. Is there a way to close the spreadsheet saving the new
data automatically without any user input

Thanks

Excel347  
 
 
Steve





PostPosted: Wed Jan 18 09:39:09 CST 2006 Top

Excel Programming >> Save an excel file in vbscript without user prompt At the start of your script, place the line

Const xlSaveChanges = 1

Assuming the workbook object you've created is named objWorkbook and the
application object is named objExcel, finish your script with

objWorkbook.Close xlSaveChanges
objExcel.Quit

Steve




> Hi, I am trying to edit an excel spreadsheet and then close it using
> vbscript.
>
> the script currently edits the data fine, but when it closes, it gives
> the Save prompt. Is there a way to close the spreadsheet saving the new
> data automatically without any user input
>
> Thanks
>


 
 
mattsmith2





PostPosted: Wed Jan 18 09:48:41 CST 2006 Top

Excel Programming >> Save an excel file in vbscript without user prompt Thanks very much