Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

export work but delimiter not

i do a macro

export work fine with delimet ";" but i need not delimiter "" (no spaces)

if i put "" or chr(0) it give me a TAB delimiter.

someone can help?

this is the macro

SET objSheetObject = ActiveDocument.GetSheetObject("CH01")

        objSheetObject.ServerSideExportEx v_name, chr(0),1

8 Replies
Not applicable
Author

someone can help with this?

Not applicable
Author

help

varunjain
Creator
Creator

DID YOU TRY THIS?

set obj1=ActiveDocument.GetSheetObject("CH05")

obj1.Export Path&"ABC.csv" , ""
Not applicable
Author

it gives me ["data"], " first and last caracter.

Not work.

Any idea?

varunjain
Creator
Creator

Whats exactly is your delimniter?

Not applicable
Author

i don´t need delemiter.

expected result

AAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAA

now give me

"AAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAA"

Regards

varunjain
Creator
Creator

TRY THIS

sub ExportToCSV()

path="E:\ABC\"

  set obj1=ActiveDocument.GetSheetObject("CH05")

  obj1.Export Path&"ABC.csv"

end sub

varunjain
Creator
Creator

THIS IS WORKING FINE FOR ME

sub ExportToCSV()

path="F:\ABC\"

  set obj1=ActiveDocument.GetSheetObject("CH05")

  obj1.Export Path&"ABC.csv",""

end sub