255 truncation

[mouser]

If I copy the source of a particular web page and then paste it in to Excel -
the copy-paste does not work - data is truncated
..

eg paste link in to IE

https://apps.db.ripe.net/whois/search.xml?query-string=92.41.240.207&source=ripe
select all and copy - and paste into spreadsheet A1 (as text) - the data is
truncated.

Paste it in to Word as text - and all data is pasted.

I am aware of the ODBC 255 problem and the changing of
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel


It seems to have no effect.


(I am pretty sure that I did do this in the past with the same web page and it
worked in Excel OK)

 

[GS]

By default, Excel's limit for copy/paste operations is 255 characters.
To work around this I usually enter EditMode (F2) to paste data copied
from web pages (or any other content containing html/php). Sometimes,
I'll paste in Notepad first, then edit as required, then copy/paste to
a cell AFTER entering EditMode.

Any sheets being copied also lose any characters beyond the 255 limit.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion