Results 1 to 3 of 3

Thread: Excel 95???

  1. Aug 10th, 2003, 10:23 PM #1
    lintz
    lintz is offline

    Thread Starter
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697

    Excel 95???

    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
    Reply With Quote Reply With Quote
  2. Aug 28th, 2003, 05:58 AM #2
    Matt_T_hat
    Matt_T_hat is offline
    Fanatic Member Matt_T_hat's Avatar
    Join Date
    Dec 2001
    Location
    '76 Male Body Evil-Errors: 666
    Posts
    774
    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...
    ?
    'What's this bit for anyway?
    For Jono
    Reply With Quote Reply With Quote
  3. Aug 28th, 2003, 07:59 AM #3
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974
    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
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width