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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…