Solved: Migrating frm Excel 2003 to 2007

[austenr]

Hi,

I have been given the assingment of converting code from 2003 to 2007. What pitfalls has anyone encountered? Thanks

[rory]

So far pretty much everything I have used in 2007 that was made in prior versions has worked without issue, at least as far as functionality - the commandbars all end up on the add-ins tab and I haven't yet had a chance to look at migrating that to use the new Ribbon XML formats. The only things I have encountered have been a couple of minor tweaks to code that works with charts - mostly rearranging the order of lines of code - but that's not surprising given that the whole chart model has changed! The only other thing I've come across is some performance issues, especially with large pivot tables.
However, I can't claim to have done that much tinkering yet.
FWIW.
Rory

[RichardSchollar]

Lookout for any legacy code using Application.FileSearch as FileSearch is no longer available in VBA in 2007.

Richard

[tipscentral]

So do we have any way of handling files using VBA in 2007? Basically, I just want some VBA code to look in a certain hard drive folder, loop through each file name and rename it using a name that I specify on an Excel worksheeet.

[Bob Phillips]

Same as you would with 2003. Look at Dir and Name in VBA help.