This is something that would be better addressed in the Microsoft Excel forums, as those folks would be the experts as far as the necessary Excel APIs needed etc. If you need any QlikView APIs, you will find those in a QVW file from the following link:
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.