View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AH AH is offline
external usenet poster
 
Posts: 1
Default Copying from excel sheet on IE webpage

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"