Copy internet page to Excel

G

Gordon

Is there any way you can copy an internet page to excel using a VBA
program? I now manually do a select all and copy to clipboard.
 
D

Don Guillett

You didn't give the url but try selecting the table desired>right
click>import to microsoft excel.
 
G

Gord Dibben

Tools>Macro>Record New Macro.

Go through the steps you now do manually and you will create a macro which you
can assign to a button or shortcut key combo.


Gord Dibben MS Excel MVP
 
Top