Data export with using VB script

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have 2 questions for data export from QV.

I would like to export csv data with using macro(VB Script) when it reloads new row data.

Could you please take a look my questions below? Many thanks!

*Please be noted that this questions contain general matter other than QV. THANKS!

<What I want to do>

- Export one specific object on QV with removing the first row of that object (first row in this case = field labels)

- File format is 'csv'

<The VB script I have>

sub Export

set obj1 = ActiveDocument.GetSheetObject("CH08")

obj1.ExportBiff "C:\Users\firstname.familyname\Desktop\Conversion\latest.xls"

msgbox("Done")

end sub

<Questions>

1) I would like to get the advise for the VB script above in order to remove the first row.
* I just need to export the data after 2nd row.

2) I would like to know the script for naming file name. the rule for file naming in this case should be: latest_YYYYMMDD.csv

Regards,

Eitoku

Re: Data export with using VB script

beck_bakytbek — Tue, 11 Apr 2017 07:36:58 GMT

hi aaa,