asked on Script for OneDrive to Excel
Hello,
I have thousands of files in OneDrive and I would like to be able to capture the names of them as well at hyperlinks to the file in a spreadsheet. All of the files are sync'd to my local machine so it would be grabbing the name and setting a hyperlink for the location. Is that even possible? If that is not possible, the name column exported to CVS will have to work.
Thanks!
I have thousands of files in OneDrive and I would like to be able to capture the names of them as well at hyperlinks to the file in a spreadsheet. All of the files are sync'd to my local machine so it would be grabbing the name and setting a hyperlink for the location. Is that even possible? If that is not possible, the name column exported to CVS will have to work.
Thanks!
PowershellCloud Computing
Last Comment
Bryant
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
After reading your comments I went another route. What I ended up doing was sharing the folder in OneDrive to everyone in the office so they could search within OneDrive itself and not worry about a spreadsheet. The owner was worried about security at first, but after they saw other users would only be able to see what was shared they were fine.