i have this routine [attached Generate_employee_list.txt --1.32 Kb]

Wich generates a string with the data in a Xl sheet, then i load with ..Navigate from a webbrowser control i have in a form, if the sheet has only three rows with data the webbrowser works fine [ attached Mypage.Html 530 b], however , if the rows are larger than three, the control doesn't load the StrURL variable where i keep the string.[attached Mypage2.Html 811 Bytes].

i have already tried changing the Line variable data type [just in case the memory in the string datatype was not enough for the string to load the entire amount of characters], Non sucessfull, but i check out the code in both pages and cannot seem to be anything weird, [ besides the poor design, to implicate that the document is not well formed]

hereby i let the attachments so somebody can tear my poor programming skills :(

Gracias /thanks and regards...

--
PD: i also posted this msg to Ms.Public.es.Excel
--
--
Tambien puedes visitar
--
Walter R . [zz]

There is a limit to the length of a URL in IE - think it's around 2k
characters or just over. If your HTML is longer than this then it won't
load.
Try navigating to "about:blank" then opening the document and writing your
string.

You might want to allow some time for the page to load before opening it to
write the HTML

Haven't looked at your code - most here will not download attachments.

Tim


"zz" wrote in message
...
i have this routine [attached Generate_employee_list.txt --1.32 Kb]

Wich generates a string with the data in a Xl sheet, then i load with
..Navigate from a webbrowser control i have in a form, if the sheet has only
three rows with data the webbrowser works fine [ attached Mypage.Html 530
b], however , if the rows are larger than three, the control doesn't load
the StrURL variable where i keep the string.[attached Mypage2.Html 811
Bytes].

i have already tried changing the Line variable data type [just in case the
memory in the string datatype was not enough for the string to load the
entire amount of characters], Non sucessfull, but i check out the code in
both pages and cannot seem to be anything weird, [ besides the poor design,
to implicate that the document is not well formed]

hereby i let the attachments so somebody can tear my poor programming skills
:(

Gracias /thanks and regards...

--
PD: i also posted this msg to Ms.Public.es.Excel
--
--
Tambien puedes visitar
--
Walter R . [zz]

Thanks Tim, didn't knew about the character limit for Url.

--
--
--
Tambien puedes visitar
--
Walter R . [zz]

"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
There is a limit to the length of a URL in IE - think it's around 2k
characters or just over. If your HTML is longer than this then it won't
load.
Try navigating to "about:blank" then opening the document and writing your
string.

You might want to allow some time for the page to load before opening it
to write the HTML

Haven't looked at your code - most here will not download attachments.

Tim


"zz" wrote in message
...
i have this routine [attached Generate_employee_list.txt --1.32 Kb]

Wich generates a string with the data in a Xl sheet, then i load with
.Navigate from a webbrowser control i have in a form, if the sheet has
only three rows with data the webbrowser works fine [ attached Mypage.Html
530 b], however , if the rows are larger than three, the control doesn't
load the StrURL variable where i keep the string.[attached Mypage2.Html
811 Bytes].

i have already tried changing the Line variable data type [just in case
the memory in the string datatype was not enough for the string to load
the entire amount of characters], Non sucessfull, but i check out the code
in both pages and cannot seem to be anything weird, [ besides the poor
design, to implicate that the document is not well formed]

hereby i let the attachments so somebody can tear my poor programming
skills :(

Gracias /thanks and regards...

--
PD: i also posted this msg to Ms.Public.es.Excel
--
--
Tambien puedes visitar
--
Walter R . [zz]