Macro to export my Object To CSV

[Anonymous]

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]

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

[Anonymous]

Yep, it's on System access.

[#4 · Accepted solution]

Hi,

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

Thanks & Best Regards,

Kuldeep Tak

[Anonymous]

hoooooooo,

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

thankss