Excel Macro to cut and paste data from Internet Explorer

I need to get a macro developed for Excel 2003 on Windows XP (or alternatively a VB Script or Java Script) which undertakes the following.


I need to copy all the contents from an Internet Explorer page currently being navigated and pasted into an Excel spreadsheet (the reason being that the Internet Explorer page would have various infromation that I need to manipulate into a slightly different format, and I want to make this as stream lined as possible rather than getting the user go and open a spredsheet, switch back to IE, copy contents, switch back to Excel, and paste it in).

I envsiage this working as an Excel macro as follow:

- Excel macro to be launched by a button located in a spreadsheet.

- Macro to switch to a specific instance of Internet Explorer (i.e. it would have a defined window name)

- The macro would then do the equivalent of Select All (CTRL-A) and Copy (CTRL-C)

- The macro would then paste the contents of that page into a seperate spreadsheet tab

- That's it. (I would write various formulas to manipulate the content that has been pasted into the appropriate format).

I appreciate that this may not be technically feasible within Excel (not sure if it can control other applications). I'm also happy for a VB Script or Java Script application which achieves the same result, i.e.:

- Script copies content of a defined Internet Explorer session (i.e. based on window name) currently open to the clipboard

- Script launches a defined Excel spreadsheet

- Script pastes the contents of the clipboard into an Excel spreadsheet.

I really don't care which method is used to achieve the result. I think it's quite simple to do, but just don't have the time to freshen up my skills.

Evner: Javascript, Script Installering, Visual Basic, Windows Skrivebord

Se mere: excel macro internet explorer, excel macro internet, macro excel internet explorer, macro excel internet, macro internet explorer excel, excel macro paste, excel internet explorer macro, excel macro data internet, excel macro paste data, excel macro ctrl, excel macro paste clipboard, excel macro open internet explorer, excel macro clipboard, macro copy data internet explorer excel, ctrl excel macro, internet macro excel, excel macro open internet, macro cut paste, macro internet explorer copy paste, macro internet excel

Om arbejdsgiveren:
( 2 bedømmelser ) Queen Victoria Building, Australia

Projekt ID: #185553

Tildelt til:


hi,please see PMB.

$30 USD in 0 dage
(6 bedømmelser)

4 freelancere byder i gennemsnit $48 på dette job


I already have implemented this using visual basic, but I include an IE control in a VB form to have full control of the navigation process and from VB open an already existing excel book to copy and paste all the cont Flere

$80 USD på 1 dag
(0 bedømmelser)

Looking forward to working with you

$50 USD in 0 dage
(0 bedømmelser)

i have it already developed , needed something similar in the past

$30 USD på 1 dag
(0 bedømmelser)