dash & export to excel ....
dash & export to excel ....
(OP)
I have problem with a field (Text). When I tried export data to Excel a have an error:
Automation object error on line...
this line looks like:
.Range(ExcelZRange).value=doc1.Dzialania(0)
when text in this field is started started from dash (-) then I can not export data to excelsheet...
I tried:
Cstr(doc1.Dzia³ania(0)) <- don't help...
and @Trim <- help, but to not all fields ...
Do you know where can be a problem or how can I solve it without removing dash .... from filed..
Best regards from Poland to everyone
jb
Automation object error on line...
this line looks like:
.Range(ExcelZRange).value=doc1.Dzialania(0)
when text in this field is started started from dash (-) then I can not export data to excelsheet...
I tried:
Cstr(doc1.Dzia³ania(0)) <- don't help...
and @Trim <- help, but to not all fields ...
Do you know where can be a problem or how can I solve it without removing dash .... from filed..
Best regards from Poland to everyone

jb

RE: dash & export to excel ....
.Range(ExcelZRange).value = {"} & doc1.Dzialania(0) & {"}
Big thanks to .::AleX::.