Excel 2002: Can I attach different file formats to excel files ?

[Guest]

Dear Sir,

I have workings in MS Excel Worksheet that are related to files in other
formats.

These formats are PDF, MS Words, MS Outlook in HTML formats etc. All of them
are saved in the same folder as the Excel file

I need to collect all these file into my Excel Worksheet. I hope to open
only one Excel worksheet to get all the related file attached to it.

May I know if this is possible in Excel 2002 or Excel 2007 ?

If yes, could you show me the steps please?

Alternatively, Can I create hyperlink in my Excel Worksheet in order for me
to pull out all the other related files when I open it ?

If yes, could you show me the steps please?


Thanks

Low

 

[Guest]

To create hyperlink:

Right click on cell and select "Hyperlink"

in the "Insert Hyperlink" form:

Select a file and click OK

Hyperlink will appear in the cell.

 

[littleccguy]

You could also look at inserting objects.