Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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