4 Replies Latest reply: Jan 8, 2013 11:09 AM by nassim kasdali RSS

    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