G'day, I have searched this forum countless times to find solutions to complex excel problems but this is my first post. I am trying to come up with a solution to speed up field collection of data on a tablet. I would normally turn to relational database solutions for this but this is something that will be used for about 100 or so inspections and then shelved so I don't want to waste too much time and money on it. My investigations have also led me to believe that I will face the same issues with excel or a database anyway in relation to capturing an image and storing the link in the correct place. It is not ideal but I can build all the relational tables and conditional dropdown boxes in excel so if it can manage the image handling somehow then it will do.
OK, so here is the problem...... I need to be able to put a button in a cell that, when clicked, launches the tablet's rear camera and allows me to take a photo, and somehow copies the path to the photo and pastes it into the excel cell where the button is located. I need to be able to take more than one photo per row (record) so I am assuming that having the button in the cell is the way to go but it may also be possible to use some logical arguments to use one button per row which tests the row/column (cell reference) for ISBLANK or similar and moves to the next column if =false (just a thought).
Pasting the actual image into the cell would be fine too but I don't believe that there's any way to paste an image into excel (have to use the insert menu, which I suppose could be scripted once the link is on the clipboard???). I don't mind using macros, VBA, external scripts, batch files, whatever I need to to make this work.
Does anyone have any suggestions about how it can be achieved?
Cheers!
(P.S. Just a thought, I can run excel on Android too but obviously scripting requirements would be very different)
OK, so here is the problem...... I need to be able to put a button in a cell that, when clicked, launches the tablet's rear camera and allows me to take a photo, and somehow copies the path to the photo and pastes it into the excel cell where the button is located. I need to be able to take more than one photo per row (record) so I am assuming that having the button in the cell is the way to go but it may also be possible to use some logical arguments to use one button per row which tests the row/column (cell reference) for ISBLANK or similar and moves to the next column if =false (just a thought).
Pasting the actual image into the cell would be fine too but I don't believe that there's any way to paste an image into excel (have to use the insert menu, which I suppose could be scripted once the link is on the clipboard???). I don't mind using macros, VBA, external scripts, batch files, whatever I need to to make this work.
Does anyone have any suggestions about how it can be achieved?
Cheers!
(P.S. Just a thought, I can run excel on Android too but obviously scripting requirements would be very different)
Last edited:
