View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Randy Harmelink Randy  Harmelink is offline
external usenet poster
 
Posts: 122
Default write all data from web import into single cell

Depending on what you're trying to do, I may have a free open-source
add-in that can help. The add-in, documentation on its functions, and
sample templates, can be found in the files area of this Yahoo group:

http://finance.groups.yahoo.com/group/smf_addin/

One of the functions gives you the equivalent of the MID() function on
HTML source code. For example:

=RCHGetWebData("http://www.google.com",1,200)

....would get you the first 200 bytes of that URL. Since an EXCEL cell
can only contain 32767 bytes of data, it does limit the returned data
to that length.

On Oct 17, 6:07 am, !!! wrote:
it's this posible in excel/vba?
write all data from web import into single cell (concatenate all data and
write to a single cell)