<span style='font-family:Verdana'><span style='font-size:12px'><br />
Mr. Roberts,<br />
<br />
I tried your suggestion about the varialble.quit() usage but still get the same results.<br />
<br />
What normally happens is that I open up the excel file, and make it visible. I then try to populate two cells,<br />
at the last row + 1 with text, then try to save, close and quit. What occurs is that, either, sharing violations<br />
occur, and the script crashes, or another instance of excel pops up, with a save dialog box, asking to save<br />
with a random filename generated by the OS, I presume. Yesterday, I noted that there were over 15 of these<br />
randome filenames saved in the directory of the exce file, but all lacking an .xls extension. This occured<br />
eventhough, I chose not to save the excel file when the save dialog window came up. <br />
<br />
No matter what I do, the workbook does not close and quit, silently saving all changes, it either crashes or<br />
aks to save the file, providing a different filename. <br />
<br />
Thanks for the reply,<br />
LG<br />
<br />
<blockquote style="border-left: #ccc 1px solid; margin: 0px 0px 0px 5px; padding-left: 5px" type="cite">
        <p style="margin:0px; padding:0px;" >
                <span style="font-family: Verdana"><span style="font-size: 12px">----- Original Message -----</span></span></p>
        <p style="margin:0px; padding:0px;" >
                <span style="font-family: Verdana"><span style="font-size: 12px">From: python-win32-request@python.org</span></span></p>
        <p style="margin:0px; padding:0px;" >
                <span style="font-family: Verdana"><span style="font-size: 12px">Sent: 08/23/11 03:00 AM</span></span></p>
        <p style="margin:0px; padding:0px;" >
                <span style="font-family: Verdana"><span style="font-size: 12px">To: python-win32@python.org</span></span></p>
        <p style="margin:0px; padding:0px;" >
                <span style="font-family: Verdana"><span style="font-size: 12px">Subject: python-win32 Digest, Vol 101, Issue 22</span></span></p>
        <br />
        <div>
                <div>
                        <pre style="word-wrap: break-word; white-space: pre-wrap">
Send python-win32 mailing list submissions to
        python-win32@python.org
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
        python-win32-request@python.org
You can reach the person managing the list at
        python-win32-owner@python.org
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 <sirgnip@gmail.com>
To: mhammond@skippinet.com.au
Cc: python-win32@python.org
Subject: Re: [python-win32] SHOpenFolderAndSelectItems
Message-ID:
        <CAH30xazCoEGiJfAo=Oo8pJ_CCwgb_McA6iOtp5zEQjMw9GW_DA@mail.gmail.com>
Content-Type: text/plain; charset="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 <skippy.hammond@gmail.com>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 <timr@probo.com>
To: Python-Win32 List <python-win32@python.org>
Subject: Re: [python-win32] Opening, Modifying, and Saving an Excel
        File from Python?
Message-ID: <4E52C3BF.8050603@probo.com>
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, timr@probo.com
Providenza & Boekelheide, Inc.
------------------------------
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
End of python-win32 Digest, Vol 101, Issue 22
*********************************************</pre>
                </div>
        </div>
</blockquote>
<p style="margin:0px; padding:0px;" >
        Ā </p>
<br />
<br />
<br />
<span id="editor_signature"><span style="font-family: Verdana; font-size: 12px">Regards, <br />
Little Guy</span></span><br />
<br />
</span></span>