How to access a file with illegal characters in file name?

Dear friends

I am trying to download a Excel file from a website which seems like running on a java server.  That file name contains the question mark in its file name so that I can't use workbooks.open method to open it in my Excel.  It works only with web browser.

What can I do to get the data from that Excel file into my spreadsheet automatically

Thank you for your help.


Answer this question

How to access a file with illegal characters in file name?

  • Arnar Vilhjalmsson

    George, have you got a bit more input on that filename It's most unusual to have a question mark in the name of a file, so I would love to know what OS the server is running, and if you could tell me the complete filename that would hepl too.

    Using the default IO classes is going to be tough if we're stuck with that question mark: the Path.InvalidPathChars is used by all those classes, and it includes the question mark. We might have to epxlore making a different access class.

    Thanks,
    Kit

  • How to access a file with illegal characters in file name?