how do I open a version controlled spreadsheet on SharePoint?

All,
If I try to open an excel workbook on SharePoint from a Document Folder that does not have Version Control, it works fine.
I am using this simple code:

Please Login or Register  to view this content.

However when I try to do it from a folder that has revision control, I get Error #1004. However the path does exist, the file is not being used by another program and I am not tying to save the workbook. If I click the file location in SharePoint, SharePoint asks me if I want to open the file as read only, or check the file out and edit it. For the purposes of my program, read only is fine.

I have also tried adding Readonly:=True to the open line like this:

Please Login or Register  to view this content.

but that does not work either.
Suggestions?
Thanks

I have not figured this out, but was able to find code on the web at MrExcel from Mav55th that allows one to make a local copy. that can then be opened and killed using the normal routines.
Here is his code, and thanks to him who ever he is.

Please Login or Register  to view this content.