Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dash & export to excel ....

Status
Not open for further replies.
mutancik

mutancik

Programmer
Dec 8, 2002
3
PL
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 [pc]
 
Sort by date Sort by votes
There is a solution... just add:

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

Big thanks to .::AleX::.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

pmonett
  • Locked
  • Question
Script to make a PDF from a Word document - execution issues
Replies
0
Views
841
pmonett
pmonett
MrWilson
  • Locked
  • Question
button click to send mail
Replies
0
Views
799
MrWilson
MrWilson
cmaynard
  • Locked
  • Question
Domino Directory view to show user's mail template
Replies
1
Views
859
hume
hume
pechettysuguna
  • Locked
  • Question
Export to Excel - selected document of view 1
Replies
1
Views
246
pmonett
pmonett
TheAtomic
  • Locked
  • Question
Excel and Notes Email question
Replies
1
Views
820
pmonett
pmonett

Part and Inventory Search

Sponsor

Back
Top