ExportBiff as ReadOnly file

amien — Thu, 16 Apr 2009 15:07:12 GMT

is this possible? i dont see any options like true,false like VB.NET has. Manual is not clear about this.

ExportBiff as ReadOnly file

Anonymous — Thu, 16 Apr 2009 15:18:47 GMT

I guess you could export the file and then run a check on the read-only state of the file. Here's a snippet of vbscript I found online:

' ------ SCRIPT CONFIGURATION ------
strFile = "<FilePath>" ' e.g. d:\mysecretscript.vbs
boolReadOnly = True ' True = read-only, False = not read-only
' ------ END CONFIGURATION ---------
set objFSO = CreateObject("Scripting.FileSystemObject")

' Change this to GetFolder to hide/unhide a folder
set objFile = objFSO.GetFile(strFile)

if boolReadOnly = True then
if objFile.Attributes AND 1 then
WScript.Echo "File already read-only"
else
objFile.Attributes = objFile.Attributes + 1
WScript.Echo "File is now read-only"
end if
else
if objFile.Attributes AND 1 then
objFile.Attributes = objFile.Attributes - 1
WScript.Echo "File is not read-only"
else
WScript.Echo "File is already not read-only"
end if
end if

topic ExportBiff as ReadOnly file in QlikView

ExportBiff as ReadOnly file

ExportBiff as ReadOnly file