I am trying to programmatically download, copy, import or any other way
cajole the contents of a specific web page onto an Excel Worksheet.

I have previously had some discussion with Dysgraphia so if he's still out
there apologies for this more specific re-posting.

I have tried:-
Dim webBk As Workbook
Set webBk=Workbooks.Open("http://www.somewebpage.com)

But I get a runtime error message saying MS Access cannot access the file
"http://www.somewebpage.com" because either it doesn't exist or is being used
by another program €“ neither of which is true. However the website does
require a UserName & Password and I think this is where this method falls
down.

So then I have tried:-
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = True
.Navigate "https://www.somewebsite.com"
End With

This brings up the site, and I can then manually enter the security details
and get to the required page. But I don't then know the code needed to
transfer it to Excel.

Also is there any programatical way round the problem of having to log in to
the site. I believe Excel provides the means of using a Personal Digital
Signature, but haven't a clue where to get one. This application is all
private.
A
ny suggestions would be most welcome.
--
donwb