how to find Excel file exist or not in vbscript code

Thread Rating:

Thread Modes

how to find Excel file exist or not in vbscript code

Veera0383 Offline

Junior Member

Posts: 2
Threads: 1
Joined: Feb 2013
Reputation: 0

08-21-2013, 02:08 PM (This post was last modified: 08-21-2013, 02:22 PM by Veera0383.)

Hi,

Below code might help you...

Code:
set objFSO = createobject("Scripting.FileSystemObject")

objFSO.FileExists("C:\FileFolder\Filename.xls")

Veera

For checking File not exists you can use the below

Code:
If not objFSO.FileExists("C:\FileFolder\Filename.xls") then

Your Action...

End if

Find

« Next Oldest | Next Newest »

Messages In This Thread

RE: how to find Excel file exist or not in vbscript code - by Veera0383 - 08-21-2013, 02:08 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	General run error when Exist fails	msacks	1	1,851	02-08-2019, 02:12 AM Last Post: Ankur
	how can i click a macro button in excel using vbscript	arpan	1	3,742	10-03-2017, 06:27 AM Last Post: supputuri
	[UFT 12.52/VBScript] Test object exist, is visible and enabled before take an action	sparkwanted	0	3,640	02-07-2017, 12:28 AM Last Post: sparkwanted
	How to find a file after downloading	UFT_Newbie	1	2,969	09-18-2014, 08:43 PM Last Post: UFT_Newbie
	Can any of the line in notepad file be appended/updated/modified via QTP(VBScript)?	rookie_automator	1	2,548	08-22-2013, 07:13 AM Last Post: basanth27

Users browsing this thread: 1 Guest(s)