Thread
:
String vs LONG format
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
String vs LONG format
The result of the evaluation of Range("T" & fila) presumably returns a
string? What do you mean when you say "the info received is much longer",
a string is a string! Long vars refer to a numerical value not a string.
You could convert the value to a string using Cstr(Range("T" & fila)) but
you probably need some error checking to avoid error values, nulls etc.
--
Regards,
Nigel
"Ruth" wrote in message
...
Hey guys,
Any idea about how to solve this?
I want to copy some cells in EXCEL to a form in WORD. The problem is when
the cells in EXCEL contain some long paragraphs of text. I have done it in
the following
way:
If wdFF.Name = "Text3" Then
wdFF.Result = Range("T" & fila)
End If
Text3 is the field in the form where the info should be inserted. If I
copy
and paste manually the info to the field in the form it works fine but
with
the code above it does not work because it seems the object wdFF is
expecting
to see only a string and the info received is much longer. Is there any
way
to modify the format of the object wdFF from string to long?? or should I
cut
and put together later on?
Thanks!!
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]