write all data from web import into single cell

[Guest]

hi,
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)

Thank you

 

[Guest]

Be careful of the limitation in excel. There is a 256 character limit in the
number of characters that you can see in the excel worksheet. Cell can
contain up to 64K of data. It is probabbly better that you import the data
and then combine the data if necessary. Is there a reason you want
everything in a single cell? Would it be better to export data to a text
file then combine the data into a single cell? How do you plan to use this
data?

 

[Randy Harmelink]

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.

 

[Randy Harmelink]

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.

 

[Guest]

i'm importing a web page with a web query and i want to save the data in the
cell A1 ...
it's possible?

 

[Randy Harmelink]

I don't think you can with a Web Query. That process is designed to
parse the data into individual cells.