A
AH
Hello all,
I need to be able to copy the contents of excel from a
webpage using VBA. I can already open IE and navigate to
the page, but I am having trouble figuring out the syntax
to select the cells and copy it to another sheet. See
below. Any help would be greatly appreciated. Thanks.
Dim ieApp As Object
Set ieApp = CreateObject("InternetExplorer.Application")
ieApp.Visible = True
ieApp.Navigate "http://www.webpage.com"
I need to be able to copy the contents of excel from a
webpage using VBA. I can already open IE and navigate to
the page, but I am having trouble figuring out the syntax
to select the cells and copy it to another sheet. See
below. Any help would be greatly appreciated. Thanks.
Dim ieApp As Object
Set ieApp = CreateObject("InternetExplorer.Application")
ieApp.Visible = True
ieApp.Navigate "http://www.webpage.com"