Creating File Explorer hyperlinks with Excel

[JeffCorkern]

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.

 

[Jerry Sullivan]

Jeff, I haven't worked with OneDrive- but regarding code to create File Explorer links, you'll have better results searching for the keywords "VBA Creating Shortcuts" instead of Hyperlinks.

Here's one link to example code that could be used in Excel.
It requires adding a Library reference to the Microsoft Windows Script Host Object Model.

http://www.mrexcel.com/forum/excel-...ctory-shortcut-visual-basic-applications.html

 

[JeffCorkern]

I knew I was using the wrong keyword.

I have written tons and tons of code but it's all basically re-formatting files. Modifying the "Script Host Object Model" is going to be breaking new ground for me. Learn something new every day, I guess.

Thanks for your help.

Jeff Corkern
--------------------------------------------------
Consider the following as a statement of logic, and rank it as "True" or "False":

"If people possess immortal souls, it should be possible to logically deduce this by objective analysis of their actions."

http://www.theninepointfivetheses.blogspot.com

 

[Jerry Sullivan]

Modifying the "Script Host Object Model" is going to be breaking new ground for me. Learn something new every day, I guess.

Jeff, Just to clarify- you won't be modifying that library- you are simply referencing the library which allows your VBA project to use its functions.

To do that, within the Visual Basic Editor > Tools > References...
find "Windows Script Host Object Model" in the list > check the box > Ok

 

[JeffCorkern]

Done.

Wo-o-o-w, look at all the stuff in there. Reminds me of the old 4.0 Add-ins. (Yeah, I go back a ways.)

Jeff Corkern
--------------------------------------------------
Consider the following as a statement of logic, and rank it as "True" or "False":

"If people possess immortal souls, it should be possible to logically deduce this by objective analysis of their actions."

http://www.theninepointfivetheses.blogspot.com

 

[JeffCorkern]

For anybody else who lands on this thread:

How To Use Windows Script Host to Create Shortcut with Parameters
Jeff Corkern
--------------------------------------------------
Consider the following as a statement of logic, and rank it as "True" or "False":

"If people possess immortal souls, it should be possible to logically deduce this by objective analysis of their actions."

http://www.theninepointfivetheses.blogspot.com

 

[JeffCorkern]

Fudge. It won't work. Shortcuts don't work at the OneDrive Website the way they do on your computer. They won't link. If I want to do what I want, I will have to create a copy of the physical file.

Next upgrade, I suppose.

Jeff Corkern
--------------------------------------------------
Consider the following as a statement of logic, and rank it as "True" or "False":

"If people possess immortal souls, it should be possible to logically deduce this by objective analysis of their actions."

http://www.theninepointfivetheses.blogspot.com