Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Update data from Web

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

vba courses london - Update data from Web

Resolved · Low Priority · Version Standard

Reply Tue 14 Nov 2006, 15:51Delegate Louis said...

Louis has attended:
Excel VBA Intro Intermediate course

Update data from Web

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

For upcoming training course dates see: Pricing & availability

Reply Tue 14 Nov 2006, 23:18Trainer Tom said...

RE: Update data from Web

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

Reply Tue 28 Nov 2006, 13:49Delegate Louis said...

RE: Update data from Web

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

VBA articles

· How Passwords Can Preserve Your VBA Macros
· Computer Programming Made Easy With VBA
· An Introduction To The Excel VBA Editor Screen
· Step Into The Unknown With VBA
· Company Roles in Visual Basic Training

Vba tip:

Stop Screen Flickering When Running Code

Running VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place.

To switch off the screen until the program is run enter the following code line:

Application.ScreenUpdating = False

The screen comes on automatically on completion of the program.

View all VBA hints and tips