Results 1 to 6 of 6

Thread: Excel 95 VBA

  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Excel 95 VBA

    I'm working on a project in Excel <font face="EraserDust">95 </font face=dust> <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15> and I'm looking for some on-line VBA resources for that version (the help file is not exactly forthcoming) <img src=/S/frown.gif border=0 alt=frown width=15 height=15>
    Suggestions are welcome.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel 95 VBA

    I think most of the 97 stuff will apply to 95.
    Charlotte

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Excel 95 VBA

    Thanks
    I hadn't realized what a big improvement the VBA environment in Excel 2000 was until I went backwards. Ugh!
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 95 VBA

    I'm not completely sure, but I think the collection object won't work in Excel 95. If I remember, I had to resort to using arrays.

    Do a search on the web for John Walkenbach. He wrote Excel or Windows 95 Power Programming with VBA. I wouldn't be surprised if he has a web site and he still sells this book.

    Mike

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 95 VBA

    ER... that's Excel For Windows 95... not Excel or Windows 95

    <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    Mike

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 95 VBA

    I have both of John Walkenbach's books on VBA programming in Excel (95 and 2000). There are quite some differences between Excel 95 and Excel 2000. Excel 97 is very similar to Excel 2000. So, saying that most of the code that works for Excel 97 works for Excel 95 is dangerously optimistic.

Posting Permissions

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