vba training london - VBA

Resolved · Low Priority · Version Standard

Fri 6 Jul 2007, 16:32 Delegate Dimitrios said...

Dimitrios has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

VBA

Is it possible to use VBA to copy information from webpages and then paste it into excel?

Tue 10 Jul 2007, 13:15 Trainer Anthony said...

RE: VBA

Hi Dimitrios. Interesting question! The answer is no, in all liklihood. VBA is a Microsoft bespoke programming language, while webpages come in all sorts of varieties from HTML to Flash to Java etc so integrating the two is going to be difficult. Best guess? Save your webpage to your desktop and then create a macro in Excel to load up any text up into the spreadsheet stripping it of any graphics. In all honesty you need a proper programming language (possible Visual Basic) to do this effectively.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips