| || |
Help with code
I am pretty new to QTP and am having troubles getting my code to do 3 things and I am not sure what I am doing wrong or missing. I will attach the code as a text file for anyone who can maybe give me some pointers. This is an extension of a problem I had trying to read data from the runtime datatable which I posted about before. The issues I am having I will list below.
1. The code should check on the existence of an Excel file and if found saveas the problem is I get a popup to confirm the overwrite of the file. I need to not have that popup show up or a way to mark yes to overwrite.
2. If no file is found I am creating a file and formatting the columns to text. The problem is when I export the runtime datatable to the Excel sheet it changes my formatting back to general. Is there a way to not do that?
3. For some reason I can not read one of the cells in my Excel sheet I have 2 new sheets created and of the 4 fields I need 3 import back into QTP with no problem. The other is a simple quantity so a integer but it errors out in QTP.
Please let me know if there is anything else I can do to explain the problems or if there is a resource that is available to help me figure this out.