Ακυρώθηκε

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

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 [url removed, login to view] is assigned to 3 destination cells).

Each image shall be assigned and resized to the following cells in the worksheet REPORT:

[url removed, login to view] -> AI25

[url removed, login to view] -> AI39

[url removed, login to view] -> AJ728; AJ945; C1103

[url removed, login to view] -> X1103

[url removed, login to view] -> C1131

[url removed, login to view] -> X1131

[url removed, login to view] -> C1159

[url removed, login to view] -> X1159

[url removed, login to view] -> C1189

[url removed, login to view] -> X1189

[url removed, login to view] -> C1217

[url removed, login to view] -> X1217

[url removed, login to view] -> C1245

[url removed, login to view] -> X1245

[url removed, login to view] -> C1275

[url removed, login to view] -> X1275

[url removed, login to view] -> C1303

[url removed, login to view] -> X1303

[url removed, login to view] -> C1331

[url removed, login to view] -> X1331

[url removed, login to view] -> B385

[url removed, login to view] -> Q385

[url removed, login to view] -> AF385

[url removed, login to view] -> B399

[url removed, login to view] -> Q399

[url removed, login to view] -> AF399

[url removed, login to view] -> B413

[url removed, login to view] -> Q413

[url removed, login to view] -> AF413

[url removed, login to view] -> AJ746

[url removed, login to view] -> AJ764

[url removed, login to view] -> AJ782

[url removed, login to view] -> AJ812

[url removed, login to view] -> AJ830

[url removed, login to view] -> AJ963

[url removed, login to view] -> AJ981

[url removed, login to view] -> AJ999

[url removed, login to view] -> AJ1029

[url removed, login to view] -> AJ1047

[url removed, login to view] -> C1361

[url removed, login to view] -> C1447

[url removed, login to view] -> C1533

[url removed, login to view] -> C1619

[url removed, login to view] -> C1705

[url removed, login to view] -> 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.)

Δεξιότητες: Excel, Microsoft Access, Powershell, VB.NET, Visual Basic

Δείτε περισσότερα: convert vba excel vb6, mccormick vba excel, vba excel manual calculation sheet, networking vba excel database program, discriminant analysis vba excel, optimizing vba excel, vba excel add list references, vba excel downsize selection, solidworks vba excel, odbc data vba excel, view directory name files cells vba excel, vba excel delete column, vba excel column label, vba excel action opening workbook, cut paste vba excel

Σχετικά με τον Εργοδότη:
( 3 αξιολογήσεις ) Germany

ID Εργασίας: #11779529

11 freelancers κάνουν προσφορές με μέσο όρο $375 γι' αυτή τη δουλειά

ZeusMan

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 requiremen Περισσότερα

$277 USD σε 10 μέρες
(82 Αξιολογήσεις)
5.9
iglobalvn

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. T Περισσότερα

$700 USD σε 10 μέρες
(3 Αξιολογήσεις)
5.0
VinayOnTask

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, dat Περισσότερα

$360 USD σε 3 μέρες
(10 Αξιολογήσεις)
4.1
crypthne

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 administ Περισσότερα

$250 USD σε 5 μέρες
(18 Αξιολογήσεις)
3.7
Gnus

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 σε 10 μέρες
(1 Αξιολόγηση)
1.9
mdashik89

Hi! I am Md Ashikur [url removed, login to view] web design, logo design, I am working in Microsoft Office, data entry, editing, Photoshop [url removed, login to view] give me a chance, I can do better

$555 USD σε 10 μέρες
(0 Αξιολογήσεις)
0.0
diegosorio

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 σε 5 μέρες
(0 Αξιολογήσεις)
0.0
aign

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 σε 4 μέρες
(0 Αξιολογήσεις)
0.0
JeffBr

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. Look Περισσότερα

$255 USD σε 5 μέρες
(0 Αξιολογήσεις)
0.0
$250 USD σε 6 μέρες
(0 Αξιολογήσεις)
0.0
$555 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
engrgulnawaz

Hi, I will be pleased to join your project as i possessed the required skills and experience. I have excellent skills on networking, [url removed, login to view], security, technical writing and am confidant to execute your project succe Περισσότερα

$400 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0