Printable View
I use the below to open a spreadsheet and it works fine on all versions of Excel except 1 client who is still using Excel 95. (don't know why!!)
Can anyone suggest why this may be or even better a way to get around it? When he trys to run the app he gets an "Automation Error"
Code:Public objExcel As Object 'instead of Excel.Application
Public oXLApp As Object 'instead of Excel.Spreadsheet
Don't quote me on this but I have a feeling that the SS in question has some really big issues like it's so limited as to be a load of rubbish... oh that's Office 97... Excell 95?... erm do you mean 97 or do you mean Version 5... oooooooo....... hmmm
The obviouse answer is to up-grade them. It's our job as technically expirenced users and workers to explain in laymens terms the best options and why to those who have better things to do (in their mind) than learning lots of code, jargon and techy stuff...
Excel 97 was the first version to have proper support for VB interaction, if 95 had anything at all it wasn't very useful - basically, upgrade the users' software ;)