Launch URL from code

[GraeagleBill]

I'd like to launch a URL from code and
paste the contents of the clipboard into
the field currently displaying the cursor.

I already have the text string on the
clipboard, I just can't seem to find any
methods that carry out a paste function.

I'm assuming I can Dim an application
object like IE and pass the URL?



Thanks,
Bill

[TheShabz]

Try:

Dim strUrl As String
strUrl = "http://www.google.com"
Call Shell("explorer.exe " & strUrl, 5)

Btw, that was the first hit on a Google search for "Open IE Access VBA"

[GraeagleBill]

The main question is what VBA method do I use to "paste" the contents of the clipboard into the "single" entry field in the webpage. OR, can that be passed in the Shell string somehow.

[TheShabz]

I don't think VBA supports clipboard operations. Unless I'm wrong there, your options would be to:
A) Use this (somewhat complicated)
B) Assuming the contents on the clipboard are something from a textbox, you can place a button (cmdCopy) which will write (UPDATE Query) the contents of the textbox to a table. Then you can use the shell command and do a DLookup to pull the contents from the table to the variable.

[GraeagleBill]

I already have the simple string in a VBA variable. I had placed that string on the clipboard in the believe that was the path go paste it into the one and only text field in the URL I would Shell to. I'll have a look at Allen's stuff and see if that opens any solutions.

[TheShabz]

If you have the string that contains the URL as a variable already, then the shell command should be all you need. It will open up explorer and go to whatever url is in the string.

[GraeagleBill]

I think you're confusing the URL string with the data string I want to paste. I understand the use of the URL string as applied to the Shell. However, I have a data string I want to paste into a data input pane that appears when the URL gets opened. Sort of akin to how fields of a webpage form would be populated from a cookie.

[TheShabz]

Oh so you want to interact with the web page once it's opened. That's outside my pay grade. I'm no good to you there, sorry.

[GraeagleBill]

Well, thanks for your thoughts. Maybe Allen will spot this and offer his suggestions.....or his condolences.