QTP deleting Macros and dropdowns
I have code that does the following -
1. Captures text from my app
2. Creates a new sheet in an existing Excel workbook
3. Writes the captured text to the new tab
After the code runs and I go into the Workbook, all the macros and dropdowns are erased.
Any ideas why this happens? Thanks in advance,
Re: QTP deleting Macros and dropdowns
How are you writing to the sheet? If you are using DataTable.Export then it would definitely kill everything in that sheet.