Set of 6 functions to deal with filesystem.
Gets current workbook path, searches for a file in certain folder.
6 of my most important functions since 2002
FixPath
FixPath_Not
IsThere
IsThere1
GetSon
GetPapa
Along with their versions ...
Edit 2024-10-31: Fixing IsThere1 to return true when searching full folder path instead of file.
Edit 2022-02-05: Adding FixPath_Not() to make sure there is no slash at end
Edit 2021-08-11: Adding ability to remove separator if found at end of path, to get actual Son in GetSon_Sep
Edit 2021-01-12: After few issues with files inside OneDrive, we have now the FixPath that worked on all variations (Local, OneDrive Personal or OneDrive Business), this one had ToolPath embedded in it
Edit 2020-09-30: Another issue fixed in FixPath when running from for SharePoint folders
Edit 2020-09-19: Adding ability for FixPath to get physical path if workbook is in OneDrive, or force getting the URL instead, parameter URL_ifOneDrive
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin Login
...
FileN, InFolder, Hidden, System, Directory
...
FullFileN, Hidden, System, Directory
Views 4,135
Downloads 1,438
