Skip to content

Local/Remote Path Conversion Bug #40

Closed

Description

@ERLoft
Image

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:

  1. Place the mouse cursor within the method and press F5 or the Run button in the VBA IDE (VBE)
  2. Type Run "LibFileTools.CreateODDiagnosticsFile" in your Immediate window and press Enter
  3. 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:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. ...
  5. 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.

Activity

  1. cristianbuse commented on Jul 15, 2026

    @cristianbuse
    Owner

    @ERLoft the screenshot shows an older version. Please check the latest commit

  2. ERLoft commented on Jul 16, 2026

    @ERLoft
    Author

    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!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions