Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
someone can help with this?
help
DID YOU TRY THIS? set obj1=ActiveDocument.GetSheetObject("CH05") | |
obj1.Export Path&"ABC.csv" , "" |
it gives me ["data"], " first and last caracter.
Not work.
Any idea?
Whats exactly is your delimniter?
i don´t need delemiter.
expected result
AAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAA
now give me
"AAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAA"
Regards
TRY THIS
sub ExportToCSV()
path="E:\ABC\"
set obj1=ActiveDocument.GetSheetObject("CH05")
obj1.Export Path&"ABC.csv"
end sub
THIS IS WORKING FINE FOR ME
sub ExportToCSV()
path="F:\ABC\"
set obj1=ActiveDocument.GetSheetObject("CH05")
obj1.Export Path&"ABC.csv",""
end sub