Wes:
I'm sure you will get plenty of responses on this, but I'll throw in my two
cents on issues I have encountered. The most troublesome problems for me
were file open and file save functions. Since the xls can now be xlsx, xlsm,
etc, I had to program in some tests to see which version of Excel was running.

For example, this kind of issue:

If Round(Application.Version, 0) < 12 Then
strTempWorkbookName = "TempPOMIS.xls"
strSalesPOMISName = "POMISForSales.xls"
Else
strTempWorkbookName = "TempPOMIS.xlsx"
strSalesPOMISName = "POMISForSales.xlsx"
End If

Also, when saving files, you have to be careful in which format it will
save... xls or xlsx. I actually saved a file with a suffix of XLS, but Excel
2007 actually saved it as an XLSX file, and then the user's couldn't read it.

There were a few other features that failed, but they were quickly remedied
by minor changes. Actually, all in all, it was fairly smooth. I think
Microsoft was very careful to make it as seamless as possible.

I'm sure the community will have plenty more to add.

--
Rich Locus
Logicwurks, LLC


"Wes_A" wrote:

Has anyone had any experience with EXcel 2007 macros written on XP running on
Windows 7 ?
I am considering upgrading from XP Pro to Windows 7 but very concerned that
I may have issues with existing macros.
I am sure that many others will be asking similar questions.