En curso

Create & Customize Excel VBA Macros

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

Ver más: corporation developer macros vba excel in new york city, vba excel xml create, vba excel dynamically create form, create roster using vba excel, create time simulator vba excel, create xml file vba excel, dynamically create form vba excel, vba excel resize picture range, word vba excel range, add references excel macros vba, vba excel create xml, create form vba excel, converting excel macros vba access, create dynamic fields vba excel, freelancer excel macros vba, create odbc connection vba excel, excel data create xml vba code

ID de proyecto: #11779576

Adjudicado a:

$120 USD en 3 días
(63 comentarios)
5.3

7 los freelancers están ofertando un promedio de $144 para este trabajo.

zebracaro

I can do it for you quickly and exactly .

$155 USD en 3 días
(67 comentarios)
5.5
rumarahman

I have 10 years experience with Data Processing in Excel and Web Researching. I work with: Web Search Web Scrapping Excel Access PowerPoint Data Processing Data Collecting (Using Macro) MS Office C++ Más

$210 USD en 3 días
(9 comentarios)
4.0
WilliamMarvollo

................................................................................................................................................

$120 USD en 1 día
(3 comentarios)
1.6
aign

Hello again. As i see you lowered price for this task :) I still can help you with this excel task. I have already done task similar to #1. Task #2 is quiete simple.

$111 USD en 3 días
(0 comentarios)
0.0
microtech4

Hello I've 15+ years experience in web scraping and data entry. so i can do your work easily please send me message so i can start your work ASAP. Thanks

$137 USD en 1 día
(0 comentarios)
0.0
$155 USD en 3 días
(0 comentarios)
0.0