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
