Copying from excel sheet on IE webpage

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top