Find Jobs
Hire Freelancers

Excel Macro to cut and paste data from Internet Explorer

$30-100 USD

Closed
Posted about 9 years ago

$30-100 USD

Paid on delivery
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.
Project ID: 7154404

About the project

8 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
8 freelancers are bidding on average $53 USD for this job
User Avatar
I am an experienced programmer, with more than 10 years experience. I understand exactly what you need. I promise you will be satisfied with my work. Thank you for your trust.
$60 USD in 3 days
5.0 (57 reviews)
6.4
6.4
User Avatar
Hi! I have experience with macro and can do this task good and fast .
$40 USD in 2 days
5.0 (44 reviews)
5.9
5.9
User Avatar
Greetings for the Day!!! I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details Thanks Prabakar M
$83 USD in 3 days
4.9 (20 reviews)
3.9
3.9
User Avatar
Hi, I suggest, I can write VBA script which will launch Internet Explorer(IE) and it will browse your desired web page. Once page is opened, script will then take care of CTRL-A and then copy and paste to excel. I can complete this using Excel VBA script. Kindly revert back so that we can move ahead. Thanks, manishadk
$55 USD in 3 days
5.0 (6 reviews)
3.0
3.0
User Avatar
A proposal has not yet been provided
$72 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Client, Greetings! I have gone through the details and have understood what you are looking for. I have good skills with VBA and you can see my reviews which I have received from two of my clients whom I have completed the project for. I will do this using VBA Macro over an Excel application. I have my own approach for this application but can to do it in your way as you are saying. I believe it is a one day job and I have a reasonable bid, so if you would like to start I am available to do it now. regards
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I already have a script prepared that can perform this exact task. With only a tiny modification, this can be up and running for you in a day or two. A demo of the script in action is available upon request.
$50 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of EGYPT
Egypt
0.0
0
Member since Feb 17, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.