vba courses london - Update data from Web

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Update data from Web

Louis has attended:
Excel VBA course

by - delegate Louis [3 posts] (2006 Nov 14 Tue, 15:51) Reply

I'd like to know how to run a macro that opens an html web page, copy a text/zone and paste it in Excel.
Great Thanks
Louis

RE: Update data from Web

by - trainer Tom [20 posts] (2006 Nov 14 Tue, 23:18) Reply

Louis,

Your best way around this is to use the inbuild Import External data, New Web query from the Data menu. This and other import, export methods are dealt with in our Advanced course.

Regards

Best Training

RE: Update data from Web

by - delegate Louis [3 posts] (2006 Nov 28 Tue, 13:49) Reply

How do I suscribe to the Advanced course ? Please contact me on my email. Thanks.

· Visual Basic Returns To The Macintosh
· How To Find A Good VB For Access Trainer
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training
· Should You Send Managers To VBA Training?

Vba tip:

Suspend DisplayAlerts in VBA

To stop Excel asking you things like "Do you want to delete this file...", use the following line of code at the beginning of the relevant VBA procedure:

Application.DisplayAlerts = False

At the end of the procedure make sure you use the following code to reactivate Display Alerts:

Application.DisplayAlerts = True

View all VBA hints and tips