topic Re: help in QlikView

help

Wed, 04 Sep 2013 05:18:33 GMT

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

Regards

Avadhoot

rajeshvaswani77 — Wed, 04 Sep 2013 05:22:09 GMT

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

Wed, 04 Sep 2013 05:31:42 GMT

Does it works for every type of files.

Thanks

rajeshvaswani77 — Wed, 04 Sep 2013 05:32:34 GMT

Yes

thanks,

Rajesh Vaswani

Wed, 04 Sep 2013 05:34:42 GMT

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

Thanks

Wed, 04 Sep 2013 05:57:53 GMT

Its working

Thanks

rajeshvaswani77 — Wed, 04 Sep 2013 06:31:59 GMT

can you please mark this as a correct answer

thanks,

Rajesh Vaswani