Paul Schrum has brought this to us :
I have cells of "built up" text strings like this:
="xy="&TEXT(O12,"0.0000")&","&TEXT(P12,"0.0000" )
which, when displayed, look like this:
xy=2524950.0000,341717.0000
The problem is, I want the cells to look like this:
CadInputQueue.SendKeyin "xy=2524950.0000,341717.0000"
but Excel interprets the double-quotes as deliminters in the cell
formula. I know how to get around this in a programming language
(using escape sequences), but I can't figure it out in "cell"
language. Do you know how to do it?
Note: The format I am seeking is for copying then pasting into a
Microstation VBA module.
Also posted in microsoft.public.excel.misc, but there does not seem to
be much action over there.
- Paul Schrum
Try this...
Put the cell contents into a string variable and pass that as the arg
for your SendKeyin method.
Example:
Dim sz As String
sz = Cells(?, ?).Value
CadInputQueue.SendKeyin = sz
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc