New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
If an Excel spreadsheet is not found then...

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
If an Excel spreadsheet is not found then...
sshukla12 Offline
Senior Member
****
Posts: 426
Threads: 4
Joined: Aug 2011
Reputation: 0
#2
Solved: 10 Years, 9 Months, 2 Weeks ago 03-16-2012, 10:02 AM
Hi,
U can use FSO, it will help u out.

Code:
Set fso=CreateObject("Scripting.FileSystemObject")
If (fso.FileExists(file_location)) Then
    'do something
    else
    'do something    
End If
file_location---> complete path for ur file to open/read

Regards,
Sankalp
Find
Reply


Messages In This Thread
RE: If an Excel spreadsheet is not found then... - by sshukla12 - 03-16-2012, 10:02 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Object not found during the 2nd iteration of an Action call in a For loop BGunay 0 862 04-23-2020, 07:08 PM
Last Post: BGunay
  Invalid File error importing a spreadsheet but only on a VM msacks 1 2,581 10-19-2014, 09:04 PM
Last Post: supputuri
  How to make QTP take the value of a formula in a spreadsheet? utestqa 1 2,963 07-06-2013, 04:13 PM
Last Post: Ankur
  If Text found mv8167 3 2,664 09-25-2012, 11:24 PM
Last Post: parminderdhiman84
Wink Element not found - VbWindow edj1 4 4,768 02-29-2012, 12:00 AM
Last Post: edj1

Forum Jump:


Users browsing this thread: 1 Guest(s)