VBA saveas + shell

Long story short: I was asked to fix a broken macro, but I don't program w/ VB let alone use excel more than I'm forced to. I can read and understand whats broken with the macro, but I'd rather improve it to prevent the next poor intern from having to fix it.

I wrote up some pseudo code to get my idea about what I'm looking to do across.

Please Login or Register  to view this content.

I'm just looking to save a copy of the workbook when it opens. The copy should have the same name as the workbook that opens with the extension .tmp.xls. I actually want it to be in .xls (97-2003).

Open a shell, run python, and pass the workbook name as an argument.

I've tried searching for subs written by other people to do these tasks, but I just can't seem to get it to work. I hit the beginner tuts and still made no progress.

Edit: there are no other macros in the workbook.
Edit2: code tags

Something like...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

is equivalent to:

Please Login or Register  to view this content.

(i.e. exactly as requested)
But this will not work beautifully if the user has other workbooks open.
maybe:

Please Login or Register  to view this content.

(replacing both lines quoted)

HTH