Using Sendkeys after Hyperlink opens web page

[BoxHead]

We have a db for which a supervisor has to go to the intranet, refresh a page, select & copy the data, paste it into a new excel file and then import the excel file.

I was hoping to hyperlink to the site, use sendkey to refresh data (F5), save the file and automatically import it as html.

Once the hyperlink opens the file, the rest of my code doesn't seem to run.

I've used this sort of SendKey operation in the past with excel files and its worked fine. Can it be done with web pages, or am I going about this the wrong way.


Thanks for any help.

John

 

[BoxHead]

I figured it out.

Originally, I had set the hyperlink address in the property pane for a command button. I added my sendkeys code for refreshing, selecting and copying the data on the click event of the button.

Apparently, the click event precedes the hyperlink.

On another command buton, I used

Application.FollowHyperlink

on the Click event before my sendkeys. Now my user can open the website, select all, copy and close.

I'd rather tell a user to "don't touch it" than have to explain each step.