You can use Automation to start an instance of Excel and then command it to open the spreadsheet. Why not save the pictures as image files (.bmp, .jpg, etc.) and use an Image control to display them?
John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of artandpats Sent: Sunday, December 11, 2005 12:51 PM To: [email protected] Subject: [ms_access] Open Excel document from Access I have a database which I use to manage instructions for packing service parts. Once component of the system contains photographs, saved in Excel spreasheets, which show how the parts are to be packaged and their order of packing. The users enter part number and quantity into a form and the system opens a report which contains a hyperlink to the appropriate spreadsheet. Previously I used the On Open event of the report to run the docmd.hyperlink.follow command to open up the spreadsheet for printing. However, my organization upgraded to Office XP and in the process, initiated security which treats all hyperlinks as potential virus. When I run the report now the system kicks me out of Access. I am looking for an alternative method of opening the spreadsheet from Access without using the .follow command. Thanks in advance. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/VpTY2A/lzNLAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
