Hi
I'm wanting to set up the following process

1) Use windows scheduler to open up a workbook every morning at 8am (ACTIONED)
2) Use "Sub Auto_Open" to run my code (ACTIONED)
3) The code to run reads a page from a wesbite site via an Excel webquery (one webquery in DataSet1 tab and one in DataSet2 tab)

I think I've got it to work (see code below) but have just read that send keys does not work when the screen is locked

Can you help me with the correct code to do what I need?

Many thanks for reading


Please Login or Register  to view this content.