Results 1 to 2 of 2
2002-06-09, 07:17 #1
- Join Date
- Feb 2001
- Thanked 1 Time in 1 Post
using %documents% in link (2000sr1a)
Feel v. stupid. Don't know what you call the folder tags used in win2k and others - eg %system%, %user%, so can't find a way to search for the list of them.
Is there such a thing as %documents%, and if so, will it work in pathnames for linked cells in excel? The address of my files at work and on laptop is the same once below My Documents, but the address of My Documents is different, which currently breaks links to a different workbook.
2002-06-10, 01:40 #2
- Join Date
- May 2002
- Canberra, Australian Capital Territory, Australia
- Thanked 420 Times in 349 Posts
Re: using %documents% in link (2000sr1a)
If you're linking Excel spreadsheets, the full pathname isn't required. Excel uses relative pathnames, which means that, provided the folder structure is the same between the source and target, everything should work fine.
For example, if your target is in C:My DocumentsExcelAnalysis, and the source is in C:My DocumentsExcelData, to Excel this is no different to D:WorkbookAnalysis and D:WorkbookData.Cheers,
[MS MVP - Word]