AnsweredAssumed Answered

vrf save Excel File

Question asked by mford on Aug 16, 2004
<!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>  

Outcomes