MontySharpei
09-16-2008, 06:43 AM
hello once more,
Ok so the health and safety bods have caught up with us and we now have to do risk assesments for everything ! so I have come up with the attached spreadsheet. The top half works brilliantly but im stuck on getting files attached.
If the 'click here to attach file' command button is pressed currently this activates the macro stored in module 2 which will display the open object window. I then select the file I want to attach, tick both 'link to file' and 'display as icon'. press ok and this will insert the icon into a cell that i have called RA3ATT (cellsF24:f29). My problem now is when I want to attach another file it places it over the of the previous attachment. How can I get it to drop it to the right of it say column G24??
your help would be appreiciated.
Ok so the health and safety bods have caught up with us and we now have to do risk assesments for everything ! so I have come up with the attached spreadsheet. The top half works brilliantly but im stuck on getting files attached.
If the 'click here to attach file' command button is pressed currently this activates the macro stored in module 2 which will display the open object window. I then select the file I want to attach, tick both 'link to file' and 'display as icon'. press ok and this will insert the icon into a cell that i have called RA3ATT (cellsF24:f29). My problem now is when I want to attach another file it places it over the of the previous attachment. How can I get it to drop it to the right of it say column G24??
your help would be appreiciated.