Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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"

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hide tab sheet in webpage (Excel) Tat Fatt Excel Worksheet Functions 7 July 11th 08 01:55 PM
Stop excel from copying data from one sheet to another Imajica New Users to Excel 1 November 3rd 06 06:53 PM
Stopping copying from a webpage Tadhg Excel Discussion (Misc queries) 1 June 28th 06 07:09 PM
Link from webpage to excel sheet Auto-Reply to mail in folder, using a te Excel Discussion (Misc queries) 0 July 21st 05 09:08 PM
Delete the formulas of webpage, copied & pasted on excel sheet Mustafa Abedin Excel Discussion (Misc queries) 1 June 19th 05 02:39 PM


All times are GMT +1. The time now is 08:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"