search

cristianbuse / VBA-FileTools

Useful methods for interacting with the file system
MIT License
87 stars 25 forks source link

"Invalid procedure call or argument (Error 5)" raised when calling GetLocalPath #5

Closed fdelaine closed 2 years ago

fdelaine commented 2 years ago

Hi,

I ran into your library while looking for a solution to get local file paths when shared between users across OneDrive or Sharepoint. Thanks for your work on this subject, I've been looking for a solution since months!

I encountered a bug when running GetLocalPath. An "Invalid procedure call or argument (Error 5)" is raised and issue occurs at line 1096 of the lib.

I just imported the module in a new workbook and called the function from a macro.

Note that the standalone function given on StackOverflow works properly (https://stackoverflow.com/questions/33734706/excels-fullname-property-with-onedrive/73577057#73577057).

I have not digged into the issue yet. I'll give more context if necessary.

Regards,

cristianbuse commented 2 years ago

Thanks @fdelaine

I missed the case where there is no Personal OneDrive. All I had to do was to swap the 4th line of that Do loop to be the first. Just pushed an update.