Re: How to write to \"Excel - VB Editor\" using QTP
Thanks for your reply, Jonty.
I have a driver script which executes specified scripts. I want to use excel for reporting purpose. I am planning to create one sheet per script and log all the steps to that sheet. I want to do formatting of sheet and hyperlinking to screenshots using functions in excel vbscript editor (like, workbook_Open, worksheet_activate etc.).
I can do this by using a template excel file with all the code writen in it. I just need to copy this file (and rename if needed) and log steps into this file. But I was wondering, if I can directly write into vbscript editor of excel file, so that i do not use template file.