topic Check file exist via macro in QlikView

Check file exist via macro

Thu, 19 May 2011 08:52:17 GMT

Hi all,

I am new in Qlikview and facing a problem in check file exist.

I have create a macro to check if file exist. and don't know how to call it out in script.

I want to do

if the xxx.qvd exist then do some incremental loading, if not exist will load all of record from an xls.

Here is my macro function:

Function CheckFileExist(filename)

Set objFSO = CreateObject("Scripting.FileSystemObject")

Dim result

If objFSO.FileExists(filename) Then

result = 1

msgbox ("good")

Else

result = 0

msgbox ("not good la ...")

End If

CheckFileExist = result

End Function

Please help ...

or if any other way to do so ?

Thanks~

fosuzuki — Thu, 19 May 2011 10:44:36 GMT

Hi, in the Script, you can use the filetime() function to check if a file exists.

For example:

if isnull(filetime('c:\file.txt')) then

//file doesnt exists

else

//file exists

end if

Hope this helps you.

Regards,

Fernando

Fri, 20 May 2011 03:13:06 GMT

Hey Fernando,

Thanks for you help...filetime() works ..