dash & export to excel ....

[mutancik]

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

 

[mutancik]

There is a solution... just add:

.Range(ExcelZRange).value = {&quot;} & doc1.Dzialania(0) & {&quot;}

Big thanks to .::AleX::.