Excel 95 VBA

Topic

New Reply

I’m working on a project in Excel 95 and I’m looking for some on-line VBA resources for that version (the help file is not exactly forthcoming)
Suggestions are welcome.

Reply | Quote

Replies

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

Reply | Quote

Thanks
I hadn’t realized what a big improvement the VBA environment in Excel 2000 was until I went backwards. Ugh!

Reply | Quote

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

Reply | Quote

ER… that’s Excel For Windows 95… not Excel or Windows 95

Mike

Reply | Quote

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.

Reply | Quote