G Gordon Jan 12, 2007 #1 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.
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 Jan 12, 2007 #2 You didn't give the url but try selecting the table desired>right click>import to microsoft excel.
G Gord Dibben Jan 12, 2007 #3 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
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
