ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copying from excel sheet on IE webpage (https://www.excelbanter.com/excel-programming/289995-copying-excel-sheet-ie-webpage.html)

AH

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"



All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com