topic Re: Macro to export my Object To CSV in QlikView

Macro to export my Object To CSV

Anonymous — Tue, 08 Jan 2013 16:00:41 GMT

Hi All;

i'm trying to build a macro using VBS to save my object "TB01" into c:\Test.csv , using the separator ";".

so, for this perpose , i made :

Sub ExportToFile

'Download Sheet ojbect data to CSV

set sObject = ActiveDocument.GetSheetObject("TB01")

sObject.Export "C:\TestFile.csv", ", "

End Sub

it doesnt work

in anglish it means : 'impossible to open the file c:\TestFile.csv for writing'

help please

Anonymous — Tue, 08 Jan 2013 16:06:32 GMT

Have you set the macro to "System access"? See attached Screenshot!

Anonymous — Tue, 08 Jan 2013 16:07:24 GMT

Yep, it's on System access.

Tue, 08 Jan 2013 16:09:10 GMT

Hi,

Just check the c: is not protected for writing through macro. try using d:

Thanks & Best Regards,

Kuldeep Tak

Anonymous — Tue, 08 Jan 2013 16:09:51 GMT

hoooooooo,

i found the probleme , i didn't have the rights to write into the c:\ ,

thankss