moving text from web browser control into an Access form

[davedoop]

I am trying to move text from a web page (inside a web browser control) into a form in Access 2000. The web browser control has functions for moving text on to the clip board:

wbc.ExecWB OLECMDID_SELECTALL
wbc.ExecWB OLECMDID_COPY

However, I seem to be stuck there not being able to retrieve the text from the clipboard. I would ideally like to have it in a text string in VBA for formating before placing in a form.

I tried the windows clipboard functions (from the "user32 library") but am not having any luck there (unfortunately, I am not a Windows programmer).

Any ideas from the Access and/or Windows gurus out there would be greatly appreciated!

 

[gol4]

if you are getting it to the clipboard did you try

docmd.RunCommand acCmdPaste

in access that should put what is on clip board into active control

 

[davedoop]

Fantastic! thanks!!!