Excel macro compatibility??

  [DELETED] 20:20 19 Oct 2003

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"

Be OK in older Excel?



  [DELETED] 20:51 19 Oct 2003

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.

  [DELETED] 20:54 19 Oct 2003

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


One happy bunny!


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

Elsewhere on IDG sites

Microsoft Surface Book 2 15in review

Iglooghost's hyper new music video gives a mutant take on Monument Valley

The best Amazon Prime Day Apple deals 2018

Comment ajouter de la musique à une présentation Google Slides ?