Hi,
I’m trying to get the log file for my website on an Apache server (godaddy) programmatically. In

excel 2000, I was able to do this with Workbooks.OpenText method, however, no matter what I try in

Excel 2010, it fails.

The website string i'm using is in the format

http://Username:Password@www.MyWebsi...00.000.000.log (where

the zeros represent my website's ip address)

I can open it in Excel no problem using the From Web button on the Data tab, but when I record a

macro doing this, the macro is empty. I’ve tried various attempts in excel using the other buttons

in the Get External Data group, but they all fail, so there's no point trying to capture the

actions with a macro.

I also have Access 2010 and Word 2010 if you know a way to do it with those object models.

Any help will be appreciated.

Mike