Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Macro to export my Object To CSV

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

Capture.PNG

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

help please

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

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

Thanks & Best Regards,

Kuldeep Tak

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Have you set the macro to "System access"? See attached Screenshot!Edit Module_2013-01-08_17-05-01.png

Anonymous
Not applicable
Author

Yep, it's on System access.

Not applicable
Author

Hi,

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

Thanks & Best Regards,

Kuldeep Tak

Anonymous
Not applicable
Author

hoooooooo,

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

thankss