Word & Excel macro project

CLOSED
Bids
3
Avg Bid (USD)
$183
Project Budget (USD)
$30 - $250

Project 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 required:
Excel, Visual Basic, Word
Additional Files: example.doc
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 200
in 5 days
Hire bogdanmurasan
$ 250
in 2 days
$ 100
in 6 days