Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA 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:10 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 171
Thanks: 0
Thanked 14 Times in 14 Posts
Default Open a log file on the internet with Excel 2010

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Get a log file from internet with VBA 2010 mtranchi BOOK: Excel 2007 VBA Programmer's Reference ISBN: 978-0-470-04643-2 0 September 14th, 2010 05:08 PM
Internet Explorer cannot open the internet site cathiec ASP.NET 2.0 Basics 1 October 22nd, 2005 01:30 PM
open excel file C# ? npqk VS.NET 2002/2003 2 November 26th, 2004 10:31 AM
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.