Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help

Hi

How can I find, particular file is exists or not using Macro in qilkview.

Regards

Avadhoot

1 Solution

Accepted Solutions
rajeshvaswani77
Specialist III
Specialist III

Hi,

You have to use file system object.

the code will be something like.

Set fso = CreateObject("Scripting.FileSystemObject")

If (fso.FileExists("C:\Program Files\conf")) Then

msgbox "file exists"

end if

thanks,

Rajesh Vaswani

View solution in original post

6 Replies
rajeshvaswani77
Specialist III
Specialist III

Hi,

You have to use file system object.

the code will be something like.

Set fso = CreateObject("Scripting.FileSystemObject")

If (fso.FileExists("C:\Program Files\conf")) Then

msgbox "file exists"

end if

thanks,

Rajesh Vaswani

Not applicable
Author

Hi

Does it works for every type of files.

Thanks

rajeshvaswani77
Specialist III
Specialist III

Yes

thanks,

Rajesh Vaswani

Not applicable
Author

I tried out this with Excel file but it not working...............

Thanks

Not applicable
Author

Its working

Thanks

rajeshvaswani77
Specialist III
Specialist III

can you please mark this as a correct answer

thanks,

Rajesh Vaswani