In a version-control enabled document library full of excel spreadsheets (xlsx); I am trying to read values from it.
I have no problem with the latest document, (because I couldn't find anyway to reach the documents but the URL of them with OpenWorkbook method) the latest version's URL is simple like "http://spsite/excel library/file.xlsx" and the old
version is like "http://spsite/_vti_history/512/excel library/file.xlsx".
And the old version cannot be opened and giving me the error:
The file that you selected could not be found. Check the spelling of the file name and verify that the location is correct
Is there any way to deal with it and open. The same method can open spreadsheet and take the data from it, but when it comes to the old version it cannot find the file.
I think, there must be a permission issue on this thing for the old versions but I couldn't find anything.
Thanks in advance. I hope you guys can show me the light..
View Complete Post