Käynnissä

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.

Objective:

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.

Taidot: Javascript, Komentosarjan asennus, Visual Basic, Windows Desktop

Näytä lisää: 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, excel macros internet, macro excel ctrl, internet explorer excel macro, excel macro iexplorer, excel macro internet data

Tietoa työnantajasta:
( 2 arvostelua ) Queen Victoria Building, Australia

Projektin tunnus: #185553

Myönnetty käyttäjälle:

guolibin

hi,please see PMB.

30 $ USD 0 päivässä
(6 arvostelua)
3.4

4 freelanceria on tarjonnut keskimäärin 48 $ tähän työhön

j10carrera

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 Lisää

80 $ USD 1 päivässä
(0 arvostelua)
0.0
xamdam92

Looking forward to working with you

50 $ USD 0 päivässä
(0 arvostelua)
0.0
vvladescuro

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

30 $ USD 1 päivässä
(0 arvostelua)
3.1