Copy active cell in before doubleclick script

[Mimoa]

Hi.
Can someone help me with my two problems?
I have a list of part numbers in column A - Id like to make a macro in range A using it the internet explorer will be opened. So im using the "draft" before double click. Now I am in the IE where I want to be. Its simple site with search box and button + some options for searching.

1st problem: I need to copy the value of the cell during doubleclick even - then, when the IE opens, I can paste part number into search box. when I make cell.value.copy or put in clipboard, it doesnt work - maybe because it activate the cell after doubleclick event. So Id like to have the value of the cell in clipboard, when IE window opens.

2nd problem: Automatically insert this value into searchbox - like the url was google - so insert in box and search. So I need to know how to find searchbox and search button in source html code, then join it with excel eg: Searchbox= myrange.value or paste or sendkeys ^c...

Hope I described it understandable.
Thanks in advance

[moonsaga]

Run this code first because the copy to clipboard code will not work with out it being run..

Please Login or Register  to view this content.

Try this code for the copy to clipboard after you run the above code..

Please Login or Register  to view this content.

[Mimoa]

Hi.
Thanks for reply.
Question1: The Makeform sub I should run like module or where and when - before "before doubleclick" there is just:

If VYKR.Value = True Then ' if toggle is on
On Error GoTo Start ' if window dont exist
AppActivate ("Workplace: MORA AEROSPACE : Vyhledávání - řízené výkresy/změnovky - Windows Internet Explorer")

Exit Sub
Start:
Dim ie As Object
Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")
ie.NAVIGATE "URL"
Do While ie.Busy
Application.Wait DateAdd("s", 1, Now)
Loop
ie.Visible = True
Else
....
Question2: What is the form for? On the end of sub it is deleted...

[moonsaga]

The makeform sub is to make the object instance so that the copy to clip board sub will run correctly. you can put the make form sub in a module in your personal.xlsb file that gets loaded when excel starts. you can also make a tool bar button for the makeform sub. the copy to clip board sub is put into the sheet module of your active workbook.

[Mimoa]

Now I quite understand it (dont understand how you find it out) and BTW it works...
Thanks

Now trying to copy this value to the searchbox automatically in opened window, but cannot find the searchbox in the sourcecode. Can you help me with this please, im not familiar with html code and translation into VB to comunicate.
*.mht file:
Wo.zip

[moonsaga]

HTML code i have dabbled into a little but this question is a bit over my head.. sorry.. maybe someone can answer this question for you..

[Mimoa]

OK anyway thanks a lot.
I am another step closer (recorded IE macro):
URL GOTO=file:///C:/Users/Mimoa/Desktop/Workplace%20MORA%20AEROSPACE%20%20Vyhled%E1v%E1n%ED%20-%20ř%EDzen%E9%20v%FDkresy-změnovky.mht ' THE SITE I JUMP WITH DOUBLECLICK IN EXCEL, SIMULTANEOUSLY I HAVE PART NUMBER IN CLIPBOARD
TAG POS=1 TYPE=INPUT:TEXT FORM=ID:searchForm ATTR=NAME:prop_typestring_123_editable_document_like CONTENT=abcdef ' IS WHERE I NEED SOMETHING LIKE: = PASTE OR PASTE CLIPBOARD OR SENDKEYS or clipboard value
TAG POS=1 TYPE=BUTTON ATTR=NAME:Vyhledat ' JUST CLICK ON BUTTON SEARCH - OPTIONAL

So now how to say excel macro to paste clipboard in this searchform?
Thanks in advance, searching, trying...