From top of head:
Application.Filesearch is gone.
2007 files may or may not have lots of more rows and columns. 65536 is no
longer the row limit, beware of hardcoded values.
You can not put sheets from one workbook to another if they have different
smount of rows.
Toolbars and menus are gone. You may want to put macro access onto the
ribbon. See
http://www.rondebruin.nl/tips.htm on how.
SaveAs may need more info on filetype and file prefix than earlier.
Almost everyting else works perfect as is.
HTH. Best wishes Harald
"Don" wrote in message
...
I will be testing the new Office 2007 to make sure things work for our
company. I have created many macro's many people are using and wonder if
anyone can tell me of anything/issues to look out for. I know that you
have
to save it as a certin format to save the Macro's , but my VB code in the
files are a bit complex so not just record and play.