Perhaps you could tell us what your script doesn't do that it should, or possibly what it does do that it shouldn't.

In general, if you can automate the process from within Excel by, say, recording a macro, it is straightforward to translate the resulting VBA to Perl, as marto explains here.

As it stands, you have too much code to wade through without any explanation of what we're looking for.

HTH,

Update: This page might explain your troubles, and offers some workarounds, at least in VBA.