PDA

View Full Version : Attach Files



SteveB
12-03-2007, 07:30 PM
Greetings from New Zealand - my first time here
Have been asked if it is possible to 'attach' (import...?) files to a workbook, in the same way one can attach files to and Access database.
These files would be available for a user to consult while they were working on/in the workbook .
When the workbook is eventually emailed to someone else, then these 'attached' files would go along with (inside...?) the workbook, ie not as separate attachments, as we would normally see with Outlook.
Any help greatly appreciated.
Stephen

Bob Phillips
12-04-2007, 01:57 AM
Stephen,

You could add hyperlinks to a file that would reference another document. This would work fine if the hyperlinks point to a server file, and the recipient is on the same network as the sender.

SteveB
12-09-2007, 02:28 PM
Hi XLD
Thanks for your reply, much appreciated.
Sorry for slow response, been away from work a few days.
Unfortunately the recipient is not on the intranet, but in another organisation.
I discovered the Insert>Object>CreateFromFile>Browse option, which works pretty well.
Have used hyperlinks quite often before, but find them to be a little fault-prone.
Cheers
Stephen :)