Pasting from Explorer or Firefox

**adam2308** · 05-20-2009, 05:27 AM

I have the following in a macro

Please Login or Register  to view this content.

I'm sure it could be tidied a lot as well but my problem is this works if i copy the data from Internet Explorer but if i copy from firefox it does not work as everything is pasted into one cell. This is something that is going to be used by about a dozen people and some use explorer while others use firefox, so it needs to suit both browsers.

Any help on how i can resolve this?

I've attached a copy of my sheet if it helps.

Cheers.

**dominicb** · 05-20-2009, 07:08 AM

Good afternoon adam2308

I haven't looked at your file as there is a lot of code to look through before I can trust it to run on my system.

However, if you're grabbing infomration from a website have you considered using Data > Import External Data > New Web Query and importing it that way. If it brings over more information than you require, then import it to a hidden sheet and pick the information off the hidden sheet that you do need. Then it's irrelevant which browser you use.

HTH

DominicB

**adam2308** · 05-20-2009, 09:48 AM

Hi,

Unfortunately a web query wouldn't be suitable for this as the info we want to copy is not in a table on the site we are using so can not be imported plus the URL is different all the time so it would also not be very user friendly for some people.

I'm thinking at the minute of having two buttons on the message box at the beginning which asks them to choose which browser they are copying from, Explorer or Firefox and run seperate code for each browser type. This is still open to possible error but should solve the problem as long as the user chooses the right button.

If anyone has any better ideas i would be very grateful to hear.

Cheers,
Adam.

**adam2308** · 05-20-2009, 10:48 AM

I think i am going to go with the idea of having two buttons on the message box at the beginning asking which browser. Can someone help me with how to create this message, one button saying 'Explorer' and the other saying 'Firefox'.

**adam2308** · 05-22-2009, 10:20 AM

I think i am going to go with the idea of having two buttons on the message box at the beginning asking which browser. Can someone help me with how to create this message, one button saying 'Explorer' and the other saying 'Firefox'.

Can anyone help with this please?

**LiamPotter** · 05-22-2009, 11:53 AM

Not sure exactly what you're trying to achieve but right at the beginning of your code is the following:

Please Login or Register  to view this content.

Have you tried changing "NoHTMLFormatting" to False?

~ Liam

**adam2308** · 05-22-2009, 12:19 PM

no, this does not work for me neither. my problem is when i paste from explorer it's fine as it is but if i paste from firefox it goes the table of data i am pasting goes into one cell so i need to paste-special text when pasting from firefox.

So, what i was thinking was, having a message box at the beginning which asks "which browser have you copied from?" with two button one saying 'Explorer' and the other saying 'Firefox'. If the user clicks 'Explorer' then the current code will be used, if they click 'Firefox' it will use the slightly adapted code to do past special - text instead.