Suppressing the dialog box when save as csv in svb - Statistica Visual Basic - Statistica - Dell Community

Suppressing the dialog box when save as csv in svb

Suppressing the dialog box when save as csv in svb

This question is not answered

 Recently a forum thread was accidently deleted. I happen to have a copy of the forum post, so I am reposting it. 

asanka asked on 2/16/2012 6:14:53 AM  (central standard time)

can any one tell me how to supress the diologbox when saving worksheet to a csv file in a SVB macro?

 

Angela Waner
Forum admin

 

All Replies
  • Recently a forum thread was accidently deleted. I happen to have a copy of the forum post, so I am reposting it. 

     rwright replied to asanka:

     

    I’ve always used the Spreadsheet.ExportText function to create CSV files.

    For example:

      Dim oData As Spreadsheet
      Set oData = ActiveDataSet
      oData.ExportText(Environ("Temp") & "\Test.csv",,,,,Asc(","),,True,True,True)

    Angela Waner
    Forum Admin