You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Thank you for opening a new issue! Please read the below and delete all unwanted text/sections before you submit your issue.
Diagnostics
Please run the CreateODDiagnosticsFile private method from the LibFileTools module. You can run it in several ways:
Place the mouse cursor within the method and press F5 or the Run button in the VBA IDE (VBE)
Type Run "LibFileTools.CreateODDiagnosticsFile" in your Immediate window and press Enter
Assign the macro to a button or shape within your host Application and then press it
Once ran, please post the resulting text file "DiagnosticsOD.txt" here. Or copy-paste its contents.
You might need to anonymize some of the information, like username, before you make it publicly available here.
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
Go to '...'
Click on '....'
Scroll down to '....'
...
See error
Additional context
Add any other context about the problem here.
Getting Subscript out of range when both running the GetLocalPath and when trying to run the Diagnostic code. This is with the new version of LibFileTools released yesterday.
Thanks for that. Very strange. I guess it's just Excel being Excel. I had to remove the module, save, close, reopen, import, save, close, reopen. Then the computers that were having issues were fixed. Thanks for your work on this and your help!
Activity
cristianbuse commentedon Jul 15, 2026
@ERLoft the screenshot shows an older version. Please check the latest commit
ERLoft commentedon Jul 16, 2026
Thanks for that. Very strange. I guess it's just Excel being Excel. I had to remove the module, save, close, reopen, import, save, close, reopen. Then the computers that were having issues were fixed. Thanks for your work on this and your help!