Excel macro compatibility??

  Chris the Ancient 20:20 19 Oct 03
Locked

I have been developing an Excel workbook in Excel XP with a Do While... Loop execution in it. Works fine in Excel XP.

However, some users will need to use the workbook in older versions of Excel (probably anything from '95 upwards).

I have a feeling that I saw somewhere that there might be backwardly (?) compatability problems with macros. But, I don't have an old version of Excel in the house to try it on!

Will a simple...

Do While ActiveCell = Date
Application.Run "xxxxxxxx"
Loop


Be OK in older Excel?

Ta

Chris

  VoG II 20:51 19 Oct 03

It should be - certainly as far back as Excel 6.

Like you, I don't have an earlier version to try it on.

I once developed an application in Excel 6 and encountered problems (resolved) when porting it to Excel 97. However, my recollection is that loops etc. worked in exactly the same way.

  Chris the Ancient 20:54 19 Oct 03

I'm glad you were on-line and I was desperately hoping that was the answer!

:o)

One happy bunny!

Chris

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…