PDA

View Full Version : Solved: Moving from 2003 to 2007



marshybid
07-04-2008, 04:20 AM
Hi All,

My company will be upgrading all machines to Office 2007 shortly.

I have about 25 macros that are stored in Personal.xls and have all been written for office 2003.

Is there a simple way of converting these for office 2007 or will I just have to run each one, after the upgrade, and see wher it crashes then individually identify the issue??

Thanks,

Marshybid

f2e4
07-04-2008, 05:03 AM
What I did was just copy them all to a notepad doc and then paste them back in.

I have not found a massive difference in the code used in 2003 and 2007.

The biggest problem I have come across is writing coed in 2007 version then trying to run in 2003.

marshybid
07-04-2008, 05:11 AM
What I did was just copy them all to a notepad doc and then paste them back in.

I have not found a massive difference in the code used in 2003 and 2007.

The biggest problem I have come across is writing coed in 2007 version then trying to run in 2003.

Thanks for the reply.

I will save my personal.xls file prior to the conversion. Hopefully 2007 is backwards compatible in the main.

I know that code for pivot tables is quite significantly different using .create instead of .add for example!!

Marshybid :hi:

mdmackillop
07-04-2008, 07:15 AM
Hi All,

My company will be upgrading all machines to Office 2007 shortly.

Marshybid

Good luck!:hairpull:

xld
07-04-2008, 08:04 AM
One thing you should do is create a trusted directory, and put all the critical workbooks in there, it makes the macro experience a lot better.

And just to give you a wamr fuzzy about the upgrade:
- the ribbon is pretty, but incredibly inefficient
- they have killed all tear-down menus
- they have hosed the colour palette
- F4 functionality has been smashed
- charting is awful, it is office charting not Excel, and macro recoding with charts is gone
- the conditional formatting dialogue is garbage
- the name manager is rubbish

But did I mention that it is pretty?

Personally, I advise all my clients not to upgrade to 2007 and wait and see if 2009 is any better.

But if you must, one tip, make the Developer tab visible, it is a must.

marshybid
07-04-2008, 08:21 AM
Based on the additional comments from mdmackillop and xld.....

I'm really looking forward to the upgrade (well that's what they are calling it!!!)

I use 2007 at home, installed on the laptop I bought, but I don't have much call for complex macros at home..... Can't think why not

Have a good week end all :beerchug:

david000
07-04-2008, 10:37 AM
1. Learn to use the Quick access toolbar. (for your Personal macros)
2. In the Options set the default save to 'Macro enabled workbook'
3. Shapes - from the drawing toolbar have different names in 2007.
4. When you go to customize the Quick access toolbar look for a button called 'Exit' (X) it will allow you to close excel with one click.
Otherwise you'll need to use Alt+F4.
5. Most important is change all your code that has 65536 or 256 hard coded to soft code! e.g. Rows.Count or Columns.Count.

xld
07-04-2008, 11:26 AM
1 5. Most important is change all your code that has 65536 or 256 hard coded to soft code! e.g. Rows.Count or Columns.Count.

Surely, nobody does that? At least no-one who has listened to my evangelising since the days when we thought MS would never, couldn't, increase the number of rows.

CaptRon
07-04-2008, 01:39 PM
My company will be upgrading all machines to Office 2007 shortly.


No way to talk them out of it? Our office recently converted to Office 2007 and what a mistake! XLD is correct....it's pretty, but that's about it. It's one little issue after another that has become so aggravating for something that disguises itself as productivity software.

Our whole office would go back to Office 2003 in a heartbeat if that were an option. I have Excel 2000, 2002, 2003, and 2007 on my machine to test for backward compatibility (dropped 97 when I added 2007). I still do 95% of my work in Excel 2003.

If you can avoid 2007, I think you are much better off. I can't think of much that is meaningful that you would gain with 2007 and there's a lot lost. But, if ya gotta....I guess ya gotta. Just my 4 cents (the US dollar isn't worth what it used to be).

Ron