in reply to Unable to retain the format in copying from one excel file to another
It's generally considered polite to mention when a question is cross-posted to another site (this one also appears on StackOverflow) so that respondents know not to make the effort of posting answers which have already been provided elsewhere.
In Section
Seekers of Perl Wisdom