Cancelado

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.)

Habilidades: Excel, Microsoft Access, Powershell, VB.NET, Visual Basic

Ver más: 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

ID de proyecto: #11779529

11 los freelancers están ofertando un promedio de $375 para este trabajo.

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 Más

$277 USD en 10 días
(82 comentarios)
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 Más

$700 USD en 10 días
(3 comentarios)
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 Más

$360 USD en 3 días
(10 comentarios)
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 Más

$250 USD en 5 días
(18 comentarios)
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 en 10 días
(1 comentario)
1.9
engrgulnawaz

Hi, I will be pleased to join your project as i possessed the required skills and experience. I have excellent skills on networking, excel.VBA, security, technical writing and am confidant to execute your project succe Más

$400 USD en 7 días
(0 comentarios)
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 en 5 días
(0 comentarios)
0.0
$555 USD en 7 días
(0 comentarios)
0.0
$250 USD en 6 días
(0 comentarios)
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 Más

$255 USD en 5 días
(0 comentarios)
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 en 4 días
(0 comentarios)
0.0
mdashik89

Hi! I am Md Ashikur Rahaman.Now web design, logo design, I am working in Microsoft Office, data entry, editing, Photoshop etc.Please give me a chance, I can do better

$555 USD en 10 días
(0 comentarios)
0.0