Wrox Programmer Forums
BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2
This is the forum to discuss the Wrox book Excel 2007 VBA Programmer's Reference by John Green, Stephen Bullen, Rob Bovey, Michael Alexander; ISBN: 9780470046432
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 14th, 2010, 05:08 PM
Friend of Wrox
Join Date: Sep 2010
Posts: 171
Thanks: 0
Thanked 14 Times in 14 Posts
Default Get a log file from internet with VBA 2010

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.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pop-ups and arguments descriptions in VBA Function (Excel 2010) sektor Excel VBA 2 May 28th, 2010 04:52 AM
Visual Studio 2010 in Focus at Great Indian Developer Summit 2010 shaguf5575 ASP.NET 1.x and 2.0 Application Design 0 February 24th, 2010 07:02 AM
Can't get Log to write the Log.txt file jnbutler BOOK: Professional XNA Game Programming: For Xbox 360 and Windows ISBN: 978-0-470-12677-6 3 July 31st, 2007 04:04 AM
vba and internet explorer ken1978 VB How-To 0 January 23rd, 2005 09:11 PM
Run VBA Excel File On Internet Explorer DHDang Excel VBA 0 November 12th, 2003 03:39 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.