JeffCorkern
New Member
- Joined
- Jul 8, 2012
- Messages
- 14
I want to put this new OneDrive cloud thingy to work.
I want to give customers access to their results files, but ONLY the files that are relevant to them.
I want to do this by creating a directory with the customer's name, then have Excel create File Explorer links to that customer's results files in a directory named for that customer, then give the customer access to that directory alone.
To repeat: I have a large directory labeled "Customer Results" with everybody's results in them.
I want to create directories named for customers, like "Poudel" and "Haggard."
Then I want to create File Explorer links in the customer-named directories to the files stored in "Customer Results".
I can't find even the slightest reference on how to do this anywhere. It's all about putting hyperlinks IN Excel files, which is not even remotely what I need. Yeah, I know I can save two copies of the files, but this would require MAJOR code re-writing.
I suspect I have come up with something Excel just can't do and only need to confirm this.
I want to give customers access to their results files, but ONLY the files that are relevant to them.
I want to do this by creating a directory with the customer's name, then have Excel create File Explorer links to that customer's results files in a directory named for that customer, then give the customer access to that directory alone.
To repeat: I have a large directory labeled "Customer Results" with everybody's results in them.
I want to create directories named for customers, like "Poudel" and "Haggard."
Then I want to create File Explorer links in the customer-named directories to the files stored in "Customer Results".
I can't find even the slightest reference on how to do this anywhere. It's all about putting hyperlinks IN Excel files, which is not even remotely what I need. Yeah, I know I can save two copies of the files, but this would require MAJOR code re-writing.
I suspect I have come up with something Excel just can't do and only need to confirm this.