I'm trying to use Excel as a catalogue for accessing a large dynamic listing of images and videos. These items would be opened using CS5 for editing purposes or other programs (virtual drives, etc.) for viewing.
Excel works particularly well for catalogue purposes and makes for a great look-up-table that's easily updated and manipulated by a number of users.
I'd like to complete the catalogue to execution gap by adding some macro buttons to the spreadsheet items that would cause the appropriate executable to initiate and the appropriate file to be opened.
I tried this approach to get started based on something that came out of a google search:
Shell ("d:\program files\adobe\adobe photoshop CS5(64bit)\photoshop.exe")
Although the path is correct - this initiates runtime error no. 63 file not found.
I'm using Excel 2003 and Windows 7 (64).
Thanks for any suggestions
Excel works particularly well for catalogue purposes and makes for a great look-up-table that's easily updated and manipulated by a number of users.
I'd like to complete the catalogue to execution gap by adding some macro buttons to the spreadsheet items that would cause the appropriate executable to initiate and the appropriate file to be opened.
I tried this approach to get started based on something that came out of a google search:
Shell ("d:\program files\adobe\adobe photoshop CS5(64bit)\photoshop.exe")
Although the path is correct - this initiates runtime error no. 63 file not found.
I'm using Excel 2003 and Windows 7 (64).
Thanks for any suggestions