Link Excel Spreadsheets

[Chuck Rich]

Is it possible to link Excel Spreadsheets within public folders? I'd like
to setup a public folder with several spreadsheet that need to link to each
other. Is this possible?

 

[Sue Mosher [MVP-Outlook]]

No.

 

[Wolfram Jahn]

No.

Of course, Sue is right.

But, depending on your needs and your sufferance, there is a work-around:

Make sure that all linked Excel sheets get opened *before* the linking
Excel sheet and that the links do not contain pathes, but only file
names (create the links while all the files reside in the same
directory). Then linking will work, because all temp files reside in the
same OLKxxx temp directory.

Moreover, you can design a custom form which collects the excel
attachments and opens them all when the user opens one.

Wolfram

 

[Sue Mosher [MVP-Outlook]]

I like that idea of having one sheet open all the others. I wonder, though,
how easy this would be to maintain. It seems like it might be a bit fragile.
I guess the proof is in the testing, right?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Wolfram Jahn]

I like that idea of having one sheet open all the others. I wonder, though,
how easy this would be to maintain.

If I can find out the Outlook temp directory name, I can open the other
attachments. Thats where I stopped - perhaps you can help out?

It seems like it might be a bit fragile.

Yes of course, what if the user starts to fumble with the auto-opened
attachments - renaming, deleting, saving elsewhere, not closing
attachments before closing Outlook item - so many questions...

Would be more stable to leave the responsibility for opening linked
attachments with the user.

Wolfram