08-04-2008, 04:07 PM
I have to delete a excel sheet before exiting the script.
Please help me out!
Thanks
-Nagesh
Please help me out!
Thanks
-Nagesh
Deleting the excel sheet before exiting the script
|
08-04-2008, 04:07 PM
I have to delete a excel sheet before exiting the script.
Please help me out! Thanks -Nagesh
08-04-2008, 05:12 PM
Hey I found this,
Code: Public Sub DeleteAFile(filespec) This is working just fine for me.
Hi,
What about the following script. It creates an excel file with 5 sheets. Then removes the second sheet. You will find the mentioned sheet deleted from the workbook. Let me know whether it works out for you or not! Code: Set xls=createobject("excel.application")
08-18-2008, 05:13 PM
Hi..
This piece of code works fine. That is interesting. Also i have posted another issue in the forum for changing the color of the cells in the datasheet. Please help me out with that too. |
« Next Oldest | Next Newest »
|
Possibly Related Threads… | |||||
Thread | Author | Replies | Views | Last Post | |
Trying to create List box in excel sheet at Run time with values yes No | JACKSPARROW | 0 | 1,685 |
01-17-2017, 11:05 AM Last Post: JACKSPARROW |
|
Excel and Driver Script | shipu | 1 | 3,756 |
02-27-2014, 09:09 AM Last Post: supputuri |
|
Custom sort -Excel Sheet | kiran | 1 | 3,832 |
01-28-2014, 09:23 AM Last Post: supputuri |
|
Can we save an exported Excel sheet directly from QTP? | Akhila | 2 | 3,414 |
11-28-2013, 10:30 AM Last Post: Akhila |
|
How to identify the object reference to the existing(already opened) Excel sheet | yogeesh | 1 | 9,918 |
09-26-2012, 07:00 PM Last Post: krr |