Find Jobs
Hire Freelancers

Bebo VBA Macro 1

$20-25 USD

Completed
Posted about 20 years ago

$20-25 USD

Paid on delivery
Please help me write a Macro that I can use in Excel/VBA that will Import an Excel worksheet from one file into another file's target worksheet. The Macro will: 1) Be invoked by a control button 2) Produce a window that will prompt the user for the location of the source file. (Standard file navigation) 3) Add TWO hard-coded alpha fields to the end of EACH row 4) Import the file into the target worksheet EX. Working from my target XLS file, I see a 'main menu' with a button that states 'Import Data'. When I click this button I get the standard file navigation window. I navigate my way to the source file and accept it. Control is returned to a window with TWO drop down boxes. The first box contains the values '12004', '22004', '32004' & '42004. I select one. The second drop down box contains two values -- 'GRADE' or 'AUDIT'. I select one. These values are added as columns at the end of the input file. The original input file will have FOUR columns and after the import process will have SIX. After the import, control is returned to the 'main menu' ## Deliverables 1) XLS worksheet with at least one control button on the active worksheet that does the import/modification as described above. Feel free to use dummy data, etc..., as I will edit the Macro accordingly. Thank you ## Platform Windows XP, OFFICE 2000
Project ID: 3099914

About the project

9 proposals
Remote project
Active 20 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
Awarded to:
User Avatar
See private message.
$10 USD in 3 days
4.7 (58 reviews)
5.9
5.9
9 freelancers are bidding on average $15 USD for this job
User Avatar
See private message.
$21.25 USD in 3 days
4.6 (167 reviews)
6.3
6.3
User Avatar
See private message.
$21.25 USD in 3 days
4.9 (156 reviews)
5.8
5.8
User Avatar
See private message.
$21.25 USD in 3 days
4.4 (58 reviews)
5.1
5.1
User Avatar
See private message.
$17 USD in 3 days
4.1 (52 reviews)
5.0
5.0
User Avatar
See private message.
$12.75 USD in 3 days
5.0 (12 reviews)
4.4
4.4
User Avatar
See private message.
$17 USD in 3 days
4.9 (12 reviews)
2.9
2.9
User Avatar
See private message.
$6.80 USD in 3 days
4.6 (28 reviews)
2.6
2.6
User Avatar
See private message.
$11.05 USD in 3 days
5.0 (5 reviews)
1.8
1.8

About the client

Flag of UNITED STATES
United States
5.0
12
Member since Feb 13, 2004

Client Verification

Other jobs from this client

Excel VBA data entry
$15-20 USD
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.