vba training london - VBA

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

Resolved · Low Priority · Version Standard

VBA

Dimitrios has attended:
Excel Advanced course
Excel VBA course

by - delegate Dimitrios [4 posts] (2007 Jul 6 Fri, 16:32) Reply

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

RE: VBA

by - trainer Anthony gold contributer [113 posts] (2007 Jul 10 Tue, 13:15) Reply

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.

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Display Text In a Msgbox On Multiple Lines

When displaying text in a MsgBox you may need to show it over multiple lines. To do this use:

vbCrLf

As in:

MsgBox "The System has detected an error." & vbCrLf & "Contact your System Administrator"

The first sentence in quotes will appear above the second in the MsgBox.

View all VBA hints and tips