Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Just check the c: is not protected for writing through macro. try using d:
Thanks & Best Regards,
Kuldeep Tak
Have you set the macro to "System access"? See attached Screenshot!
Yep, it's on System access.
Hi,
Just check the c: is not protected for writing through macro. try using d:
Thanks & Best Regards,
Kuldeep Tak
hoooooooo,
i found the probleme , i didn't have the rights to write into the c:\ ,
thankss