<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=US-ASCII"><TITLE>Message</TITLE><META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD><BODY><DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=725585811-17082004>Cecil,</SPAN></FONT></DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=725585811-17082004>Below are that ActiveX commands I use to save Excel and to disable prompts,</SPAN></FONT></DIV><DIV><FONT face=Arial color=#0000ff size=2><SPAN class=725585811-17082004><DIV><FONT face="Century Gothic"><DIV><FONT face="Century Gothic" size=2><STRONG></STRONG></FONT> </DIV><DIV><FONT face="Century Gothic" size=2><STRONG><DIV><FONT face=Arial color=#0000ff size=2>ExcelAppName.DisplayAlerts = FALSE;</FONT></DIV><DIV><FONT face=Arial color=#0000ff size=2>ExcelAppName.Workbooks(WorkBookName).Save</FONT></DIV></STRONG></FONT></DIV><DIV><FONT face="Century Gothic" size=2><STRONG></STRONG></FONT> </DIV><DIV><FONT face="Century Gothic" size=2><STRONG></STRONG></FONT> </DIV><DIV><FONT face="Century Gothic" size=2><STRONG></STRONG></FONT> </DIV><DIV><FONT face="Century Gothic" size=2><STRONG>Michael Ford</STRONG></FONT></DIV><DIV><FONT face=Arial size=2>Test Engineering</FONT></DIV><DIV><FONT face=Arial size=2>Herley Farmingdale</FONT></DIV><DIV><FONT face=Arial size=2>425 Smith Street Farmingdale, NY 11735-1198</FONT></DIV><DIV><FONT face=Arial size=2>(phone) 631.630.2000 ext 268 (fax) 631.630.2066</FONT></DIV><DIV><FONT face=Arial><SPAN class=284475519-02032004><FONT face="Century Gothic"><A href="mailto:Michael.Ford@Herley.com"><FONT size=2>mailto:</FONT></FONT></SPAN><FONT size=2>Michael.Ford@Herley.com</FONT></A></FONT></DIV><DIV><FONT face=Arial size=2></FONT> </DIV></FONT></DIV></SPAN></FONT></DIV><DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV></DIV><BLOCKQUOTE> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Cecil L Gray [mailto:cecil.gray@verizon.net]<BR><B>Sent:</B> Monday, August 16, 2004 9:21 PM<BR><B>To:</B> VRF<BR><B>Subject:</B> [vrf] save Excel File<BR><BR></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=203501101-17082004>Hi Vrfs:</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=203501101-17082004>I need help with saving an Excel file using VEE to activate automatic saving. </SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=203501101-17082004>I am entering data into Excel, at a predetermine time the file should save automatically.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=203501101-17082004>I do not want the save window to prompt.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=203501101-17082004></SPAN></FONT> </DIV> <DIV><FONT face=Arial size=2><SPAN class=203501101-17082004>Thanks for any help</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=203501101-17082004>Cecil L. Gray</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=203501101-17082004></SPAN></FONT> </DIV>---<BR>You are currently subscribed to vrf as: MFord@Generalmicrowave.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list, email "vrf@agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". </BLOCKQUOTE>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list, email "vrf@agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>