in reply to Manipulating open excel sheet

Close it.

Sorry, but TTBOMK, Excel is responsible; effectively locking access to an .xls file when opened.

...and if this is shown to be wrong, I'm gonna' learn something I sought for a long time. :-)