PDA

View Full Version : Solved: Vba to Okay Digital Cert and Signing data?



Celelond
01-24-2011, 03:22 AM
Meant this for the excel forum, SORRY!

Hi all,

I have a web page I need to access every hour, on the hour.
I can bring up a web page no issue, and prefer to leave visibility as false, but on the one I have been asked to access I have a small issue.

When I navigate to the url, it then asks to choose a digital cerificate (I have only one that I can choose).
Once I okay this manually it then pops up another box, "Signing data with your private exchange key."

Both of these use an "OK" button, does anyone know a way I can write this into my code to ok both of these and move on the url?

I would deff prefer to have it not visible and not use sendkeys and mouse clicks.

Oh, another thing, once ont he page I run a report, this then bring us the File Download box, then the Save as box, any clues as how to let the code handle them? The Save as name for the folder would be Now as in the date and time at that moment.

Thanks for your help.