Garry Bettle wrote: > > The last few lines of the WITH are: > > .DisplayAlerts = False > .Save > .Quit > ENDWITH > > This works a treat before Excel 2007 but now Excel 2007 comes up with > a dialog, asking for the user to save the file. >
The quick lazy (I don't feel like looking up the code) answer is that you need SaveAs() instead of Save. Try that, and if that doesn't get you far enough let me know and I'll get my lazy butt over to the folder where I keep that kind of stuff. :) _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
