Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to export a table chart value into a .CSV file by using macro.
The CVS file type should be Comma delimited.
How can we export like this?
I have attached sample .CSV file.
Perhaps this?
SUB EXPORT
set sObject1 = ActiveDocument.GetSheetObject("CH01")
sObject1.Export "C:\Users\Anil\Qlikview\MyDoc.csv", ", "
end sub
Check this attached thread
Hi Anil,
It is saved as .CSV and save as type is "unicode text". but i need the save as type in "CSV(Comma delimited)".
Hi Jeeva,
Here i have Enclosed Comma Delimited Pure CSV Export Using Macro