Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Deleting the excel sheet before exiting the script
#2
Solved: 11 Years, 6 Months, 2 Weeks ago
Hey I found this,
Code:
Public Sub DeleteAFile(filespec)
   Dim fso
   Set fso = CreateObject("Scripting.FileSystemObject")
   On error resume next
   fso.DeleteFile(filespec)
End Sub

This is working just fine for me.
Reply


Messages In This Thread
RE: Deleting the excel sheet before exiting the script - by nageshpv - 08-04-2008, 05:12 PM

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,783 01-17-2017, 11:05 AM
Last Post: JACKSPARROW
  Excel and Driver Script shipu 1 3,918 02-27-2014, 09:09 AM
Last Post: supputuri
  Custom sort -Excel Sheet kiran 1 3,970 01-28-2014, 09:23 AM
Last Post: supputuri
  Can we save an exported Excel sheet directly from QTP? Akhila 2 3,551 11-28-2013, 10:30 AM
Last Post: Akhila
  How to identify the object reference to the existing(already opened) Excel sheet yogeesh 1 10,133 09-26-2012, 07:00 PM
Last Post: krr

Forum Jump:


Users browsing this thread: 1 Guest(s)