Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
jeevays7
Partner - Creator III
Partner - Creator III

Export chart value into .CSV file with type comma delimited using macro

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.

5 Replies
Anil_Babu_Samineni

Perhaps this?

SUB EXPORT

set sObject1 = ActiveDocument.GetSheetObject("CH01")

sObject1.Export "C:\Users\Anil\Qlikview\MyDoc.csv", ", "

end sub

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
jeevays7
Partner - Creator III
Partner - Creator III
Author

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)".

Anonymous
Not applicable

    Hi Jeeva,

              

Macro to export straight table to csv after reload on server.

Anonymous
Not applicable

Hi Jeeva,

  Here i have Enclosed Comma Delimited Pure CSV Export Using Macro