loading xls vs xlsx files

[#1]

Hi,

I am facing an issue while loading xlsx files, I get an error saying "Cannot read from BIFF file".

However, when I save it as xls, it works fine.

So, I tried writing a macro which opens the excel files and replaces xlsx with xls. This did as it was supposed to do, however did not solve the issue as I still get the same error. Also, I will have to deploy the app on a server which will have it's own issues of running a macro.

I have been wondering about the relevance of this approach, as in the coming years, xls files might become irrelevant and outdated and as such saving files as a older file format shouldn't be the fix.

I wanted to know, if there are any alternative ways to handle this and views on the above approach.

Thanks

[anbu1984]

ScriptError: Cannot read BIFF file - Any ideas?

[#3]

hi anbu,

I had gone through that post. That's why I wanted to know if is a good practice, shouldn't there be better ways to handle this?

Also, I am not comfortable with VBA, so my code doesn't work as expected.

[#4 · Accepted solution]

loading xls vs xlsx files