We had very few. The biggest was that they dropped "FileSearch". which is used to search the filesystem for files matching specific criteria. Instead, we had to write our own version of FileSearch using the Filesystem object and the Folders and Files collections.
other than that, and the fact that all custom toolbars are now in the "add-ins" tab, it's been fairly simple. Oh yeah, if the macro runs very long, and you choose to "surf-the-net" while it runs, Excel goes to "background priority", so the macro runs even longer. Using a great deal of help from groups like this, I utilized a startup macro that "sets" the priority to "high". are you MORE worried now? or less? lol Paul ________________________________ From: TerryP <webtour...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Fri, March 12, 2010 11:14:02 AM Subject: $$Excel-Macros$$ XLS 2003 to 2007 Concerns We're finaly going to Office 2007 VBA code-wise, what issues we may have ? thanks -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
