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