Actually, I don't have a machine with Office 97 on it. I am trying to get a
copy of Excel 97 for that purpose, but this project is actually just a
freebie for a friend whose IT department said it couldn't be done. I just
laughed when she told me that. I had never programmed in VBA before last
weekend when I started on this. With about 20 hours of programming (and lots
of help from this newsgroup, thanks for all the help), I have a complete
package that combines 4 separate db query results files into one report,
complete with lots of editing and formatting. It used to take her two hours
to do this by hand and she had to do it once a week. Now it will take her 2
minutes. But now I find out that they only have Excel 97, but why does that
surprise me when the IT department said this couldn't be done.

There only seems to be a couple of incompatibilities in the arguments for a
couple of calls. 'Sort' being one of them I know about for sure. So I was
hoping I could find a reference that told about the incompatibilities.

Thanks,
Ken Loomis


"Bob Phillips" wrote in message
...
Ken,

Do you not have an Excel97 machine that you can develop on? It is better
than trying to ensure backwards compatibility.

--

HTH

RP

"Ken Loomis" wrote in message
...
I am using Excel 2003, but I need to be sure what I write in VBA will run
on
a machine with Excel 97.

Is there a reference somewhere that talks about how to make your programs
compatible with older versions of Excel?

Thanks,
Ken Loomis