Find Jobs
Hire Freelancers

Excel VBA - 13/10/2016 10:36 EDT

$250-750 USD

Cancelled
Posted over 7 years ago

$250-750 USD

Paid on delivery
Task #1: Click on the green “UPLOAD“ arrow in the worksheet TEMPLATE (row 814) to insert and resize the specified images in the designated cells in worksheet REPORT. Origin Files: All image files must be named as specified in worksheet Template/ column Q/rows 807 - 906. All image files shall be located in the Folder C:/MirfinMP. File endings “.jpg“ or “.jpeg“ shall be accepted. There can be up to 45 image files. File size may not exceed 300KB per image. Not all specified images may be available, in which case only the available images are inserted in the respective cells. Destination Cells: Each image must be sized to fit the size of the destination cell exactly. Images to have a slight shadow (if possible). There can be up 47 destination cells (image [login to view URL] is assigned to 3 destination cells). Each image shall be assigned and resized to the following cells in the worksheet REPORT: [login to view URL] -> AI25 [login to view URL] -> AI39 [login to view URL] -> AJ728; AJ945; C1103 [login to view URL] -> X1103 [login to view URL] -> C1131 [login to view URL] -> X1131 [login to view URL] -> C1159 [login to view URL] -> X1159 [login to view URL] -> C1189 [login to view URL] -> X1189 [login to view URL] -> C1217 [login to view URL] -> X1217 [login to view URL] -> C1245 [login to view URL] -> X1245 [login to view URL] -> C1275 [login to view URL] -> X1275 [login to view URL] -> C1303 [login to view URL] -> X1303 [login to view URL] -> C1331 [login to view URL] -> X1331 [login to view URL] -> B385 [login to view URL] -> Q385 [login to view URL] -> AF385 [login to view URL] -> B399 [login to view URL] -> Q399 [login to view URL] -> AF399 [login to view URL] -> B413 [login to view URL] -> Q413 [login to view URL] -> AF413 [login to view URL] -> AJ746 [login to view URL] -> AJ764 [login to view URL] -> AJ782 [login to view URL] -> AJ812 [login to view URL] -> AJ830 [login to view URL] -> AJ963 [login to view URL] -> AJ981 [login to view URL] -> AJ999 [login to view URL] -> AJ1029 [login to view URL] -> AJ1047 [login to view URL] -> C1361 [login to view URL] -> C1447 [login to view URL] -> C1533 [login to view URL] -> C1619 [login to view URL] -> C1705 [login to view URL] -> C1791 Task #2: The spelled out number in cell AJ784/TEMPLATE must be all in lower case and the currency must read “rand“ instead of “dollars“. Task #3: All inserted objects with assigned macros on both worksheets TEMPLATE and REPORT must be enabled/functional when clicked when the worksheets are in “protected“ mode. (Currently, when in "protected" mode, clicking the Objects raises the following alert: Microsoft Visual Basic Run-time error '1004': AutoFilter method of Range class failed [Abort] [Debug] Please advise the procedure to enable the intended functionality of objects in "protected" mode? (I have already tried to achieve this by unlocking the cells over which the objects and by unticking the “Locked“ tick-box in the “Format Shape“ window, but without success.)
Project ID: 11779529

About the project

10 proposals
Remote project
Active 7 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
10 freelancers are bidding on average $357 USD for this job
User Avatar
Hello, I’ve carefully gone through your job posting Excel VBA - 13/10/2016 10:36 EDT. I'm an expert in Advanced Excel VBA programming techniques. I am very much interested in your project with all of your requirements. I am always available on Email. I will be available to start your project as soon as possible in accordance with you. Thank you for your consideration, Best Regards, Ian
$277 USD in 10 days
5.0 (83 reviews)
5.9
5.9
User Avatar
Hi sir, I have read your requirement carefully. I am interested to work for this project and i will provide within or before 10 days . If you wanna confirm me, please check my work history and portfolio kindly. Then, you can know about my ability that can do your project enough. Especially, this is my experienced and successful work before Of course, I know you could be in doubt about my real ability. It would be important for me to prove my ability through real project. I hope this project would be the first step in long term partnership with you. I await your favorable reply with interest. I feel confident my execution of this order will be to your complete satisfaction. I ready to start right now . Please feel free to ask any questions and we would be happy to assist you. Regards,
$700 USD in 10 days
4.9 (4 reviews)
5.1
5.1
User Avatar
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.
$250 USD in 5 days
4.9 (36 reviews)
4.7
4.7
User Avatar
Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, data processing. I can design and develop excel, ms access applications in quick time ensuring the final output is as per the precise requirement. Over 10 yrs I've worked in VBA technology and so I am accustomed to working with all sorts of excel, access related development. You can be sure that I will use my best skills to ensure the successful completion of the project. I highly value professionalism and hold myself strictly accountable to represent client's profile. I aim to form a long term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Vinay
$360 USD in 3 days
4.8 (11 reviews)
4.2
4.2
User Avatar
Hi. I am professional in VBA scripts and office automation. I can provide very fast and quality completion of the project. Please fell free to go on with details about the project. Cheers, Georgi
$250 USD in 10 days
5.0 (1 review)
1.9
1.9
User Avatar
I have a lot of experience working with VBA and Excel. I'm sure that I can help you with your project and deliver it in a timely manner
$555 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I can help you with this excel task. Can you please provide an excel file? I have already done task similar to #1. Task #2 is quiete simple. For task #3 i need to see excel workbooks.
$277 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I can solve it. I imagine that it is not the only thing that you want me to do, so Im opened to discuss the next steps of this project. Im very responsible, comitted and experienced in excel macros and vba. Looking foward to hear from you. Cheers
$255 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of GERMANY
Rosengarten, Germany
5.0
5
Payment method verified
Member since May 26, 2016

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.