write all data from web import into single cell
 

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

write all data from web import into single cell
 

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?

"!!!" wrote:

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

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)

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)

write all data from web import into single cell
 

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" wrote:

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)

write all data from web import into single cell
 

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

On Oct 19, 5:05 am, !!! wrote:
i'm importing a web page with a web query and i want to save the data in the
cell A1 ...
it's possible?