Mr. Roberts, I tried your suggestion about the varialble.quit() usage but still get the same results.
What normally happens is that I open up the excel file, and make it visible. I then try to populate two cells, at the last row + 1 with text, then try to save, close and quit. What occurs is that, either, sharing violations occur, and the script crashes, or another instance of excel pops up, with a save dialog box, asking to save with a random filename generated by the OS, I presume. Yesterday, I noted that there were over 15 of these randome filenames saved in the directory of the exce file, but all lacking an .xls extension. This occured eventhough, I chose not to save the excel file when the save dialog window came up. No matter what I do, the workbook does not close and quit, silently saving all changes, it either crashes or aks to save the file, providing a different filename. Thanks for the reply, LG ----- Original Message ----- From: [email protected] Sent: 08/23/11 03:00 AM To: [email protected] Subject: python-win32 Digest, Vol 101, Issue 22 Send python-win32 mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://mail.python.org/mailman/listinfo/python-win32 or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of python-win32 digest..." Today's Topics: 1. Re: SHOpenFolderAndSelectItems (Scott Nelson) 2. Re: Opening, Modifying, and Saving an Excel File from Python? (Tim Roberts) ---------------------------------------------------------------------- Message: 1 Date: Mon, 22 Aug 2011 09:10:58 -0500 From: Scott Nelson <[email protected]> To: [email protected] Cc: [email protected] Subject: Re: [python-win32] SHOpenFolderAndSelectItems Message-ID: <CAH30xazCoEGiJfAo=oo8pj_ccwgb_mca6iotp5zeqjmw9gw...@mail.gmail.com> Content-Type: text/plain; ch arset="iso-8859-1" Done (ID #3396444) https://sourceforge.net/tracker/?func=detail&aid=3396444&group_id=78018&atid=551957 Many thanks for considering this! On Sun, Aug 21, 2011 at 10:15 PM, Mark Hammond <[email protected]>wrote: > On 20/08/2011 5:40 AM, Scott Nelson wrote: > ... > > Does pywin have support for SHOpenFolderAndSelectItems()? >> > > Unfortunately not - you can open a feature request at sourceforge and I'll > add it for the next release. > > Cheers, > > Mark > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.python.org/pipermail/python-win32/attachments/20110822/a315b006/attachment-0001.html> ------------------------------ Message: 2 Date: Mon, 22 Aug 2011 14:01:51 -0700 From: Tim Roberts <[email protected]> To: Python-Win32 List <[email protected]> Subject: Re: [python-win32] Opening, Modifying, and Saving an Excel File from Python? Message-ID: <[email protected]> Content-Type: text/plain; charset=" windows-1252" The Little Guy wrote: > > Hi, > > > > I apologize for the lengthy post. > > > > I?m using Python 2.7, Win 7, Excel 2003. When trying to enter a time > object and text data into a, simple, Excel 2003 file. I?ve tried > different combinations for saving the file. I?ve used > workbook.Save(), workbook.SaveAs(filename), etc. Sometimes I receive > a replace file dialog box, but other times, I receive following > message, when it tries to save: > It is important to remember that none of these cause Excel to exit: xlApp.Visible = 0 xlApp = None del xlApp If you have Excel open with your file and set Visible to 0, it can be very difficult to remember that your file is still open. You should use xlApp.Quit() in every exit path. -- Tim Roberts, [email protected] Providenza & Boekelheide, Inc. ------------------------------ _______________________________________________ python-win32 mailing list [email protected] http://mail.python.org/mailman/listinfo/python-win32 En d of python-win32 Digest, Vol 101, Issue 22 ********************************************* Regards, Little Guy
_______________________________________________ python-win32 mailing list [email protected] http://mail.python.org/mailman/listinfo/python-win32
