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
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.