Word & Excel macro project

Closed

Description

Project Description:

Word & Excel easy macro project

To work in Windows 7 & Windows 8 tablets with 1 or 2 cameras fitted (front & rear facing)

Microsoft Office - Word & Excel 2010 or newer

Need to invoke the tablet / laptop camera while in Word or excel as below. If the tablet has more than 1 camera we need easy ways to make select the correct camera - without having to change it every time the macro is invoked. We would like to hear how you propose this works - before we agree to proceed.

Deliverables are;

1 x Excel document with camera macro - 2 buttons

1 x Word document with camera macro - 2 buttons

1 x Word document with Automatic table addition & camera macro - 2 buttons

This is what we want to achieve….

We want to have the ability to add text and photos\ video using the integrated camera on a tablet\laptop to different places in the document.

Excel

I want to have a spread sheet with 2 macro buttons in the top main ribbon;

Button 1: invoke the camera to take a still photo - imbed into the document in the cell where the cursor was before pressing the button

Button 2: invoke the camera to take a video - imbed into the document in the cell where the cursor was before pressing the button

Word - document 1

I want to have a document that has 2 macro buttons in the top main ribbon;

Button 1: invoke the camera to take a still photo - imbed into the document where the cursor was before pressing the button

Button 2: invoke the camera to take a video - imbed into the document where the cursor was before pressing the button

Word - document 2

Word macro with 2 action buttons on the top ribbon and 4 buttons in the table image field

The document to have an expanding number of rows split in two columns;

The document opens initially with a table with just one row.

The cells to have a 1 pixel border on all sides both cells.

Each row has two columns - split at 50% width –

The columns should resize if the format changed from landscape to portrait at time of start.

The left cell for text entry, right cell for image.

The inserted image should auto size to fill the space.

In the right column cell - there should be three large finger press size buttons - one for photo, one for leave blank, one for finished

How it will work;

The operator presses the photo button

The camera window opens & they take the photo

On save - the image replaces the buttons AND adds a new row below ready for more the next input

The process repeats as many times as required

If they don’t want add a photo they can press "Leave blank"

This leaves the text in place - makes the image area blank and the buttons disappear AND adds a new row below ready for the next text & image. The image space should then shrink to a single line width. This is how they can add title sections in the table.

If they press "Finished"

This deletes the row completely - process stops - no more entry - no empty row visible to the operator

If they need to insert a row in the middle of the table, then we need the two buttons in the menu ribbon will allow insert above or insert below. Put the cursor in the text area of a row and select one of the insert buttons.

If the operator needs to change the image after it is saved it is OK if they simply insert a new row and delete the old row manually. If you have a better idea we are happy to hear it. We don’t want a delete or edit button visible in the file however. It would be ok if pressing on the image invoked the camera again.

Skills: Excel, Visual Basic, Word

See more: works need excel, what need for an operator, what is a shrink, want excel spread sheet, on line photo edit, microsoft excel spread sheet, microsoft excel for windows 8, make a spread sheet, i want to edit word document, how to propose a project, how excel works, fill a photo with more photos, excel macro to word, excel macro how to, excel for windows 8, amp word excel, what is microsoft word, what is microsoft project, what is macro in excel, what is a entry word, microsoft word on line, microsoft macro, macro microsoft word, how to microsoft excel, excel split columns

Project ID: #4201075

3 freelancers are bidding on average $183 for this job

diegogarcia0531

Hi, I can do the job, VBA expert, EXCEL and WORD knowledge, software developer for a several years. I am looking forward to work with you Best Regards Diego

$200 USD in 5 days
(14 Reviews)
4.6
bogdanmurasan

easy stuff

$250 USD in 2 days
(0 Reviews)
0.0
iddrus

Hi, i am ready for this job right now, please check PM :)

$100 USD in 6 days
(0 Reviews)
0.0