Html to excel web browser

**caskad** · 08-13-2010, 11:04 AM

Hello from France,

i need to paste HTML elements from webbrowser correctly.

i need to keep layout of data by respecting the line and columns.

i ve got only one line which contains all data in the cell wanted but i need one line with 5 columns. (not obvious to explain

)

It is necessary to understand that via InternetExplorer, i dn't have not this problem thanks to the special paste.

here is code:

Please Login or Register  to view this content.

Thanks for your help!

**Cheeky Charlie** · 08-13-2010, 12:10 PM

Hi, welcome to the forum, please wrap your code in code tags. (edit -> go advanced -> select the code and click the button with a # on it)

**royUK** · 08-13-2010, 12:42 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**caskad** · 08-16-2010, 08:57 AM

Originally Posted by royUK

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

opps didn't notice this rule ^^

I 'ts very difficult to explain my problem but not the code

Please Login or Register  to view this content.

In exemple i need to copy paste 1-4 Row from this site http://www.boursorama.com/

with correct format:

eg:

PHP Code:


[HTML]SOCIETE GENERALE     [Données temps réel]     42.585     -1.81%

               A1           B1                         C1          D1

It s ok with special paste under Excel 2007 but from webbrowser with a command button, it's impossible to retrieve correct format :s

i 've found this: http://www.excelforum.com/excel-prog...-in-excel.html

but no way to succeful this code

Merci !!!!

thanks

**Cheeky Charlie** · 08-16-2010, 09:25 AM

Try this:

Please Login or Register  to view this content.

(doesn't require reference to form object library)

**caskad** · 08-16-2010, 09:35 AM

Hello cheeky charlie,

it gives me an error

"Paste Special method of range class failed"

in excel 2007, i ve a lot of problem with this paste method

**royUK** · 08-16-2010, 10:26 AM

I future edit the original post, don't just enter a new one.

**caskad** · 08-16-2010, 10:41 AM

Originally Posted by Cheeky Charlie

Try this:

Please Login or Register  to view this content.

(doesn't require reference to form object library)

it works:

Please Login or Register  to view this content.

thx !

**Cheeky Charlie** · 08-16-2010, 12:16 PM

Sorry, I didn't read your code properly, (but obviously you worked it out).

To replicate your exact logic from before:

Please Login or Register  to view this content.

(i.e. paste into column T after last entry in column A)

If your table always has entries in column T if there are entries in column A then this will make no difference - if sometimes entries are missing in column T and column A is always complete this way is slightly more robust.