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