Converting Excel Macros 2003 to 2007

**magan** · 03-18-2010, 03:34 PM

Hi,

We recently converted to Excel 2007 and now our macros does not work. The person who created it is no longer with the company so we can't have them edit it. Can someone help me convert the 2003 macros so it will work in Excel 2007?

The macros is attached.

**shg** · 03-18-2010, 03:52 PM

Welcome to the forum.

What line falls over in Excel 2007?

As a general comment, the code is worse than horrible.

**magan** · 03-18-2010, 04:23 PM

I agree the code is really bad. When running it in 2007 it pops up run-time error 76 path not found. It highlights Open FileString3 For Append As #3 in the code. I put quotes around FileString3 and it accepted it. I ran it again, and it pulls up every FileString in the code. I put quotes around them all. Then at the end if pops up with error MsgBox ("The Program will HALT ** It did NOT FINISH ** - You must start over!") which is part of the code. I don't know how to fix it to make it work. The macros is designed to create work orders or "tickets" in another system automatically.

**shg** · 03-18-2010, 04:57 PM

magan, you may find some kind soul who will minimally modify that code to resolve whatever 2007 problem it has. But if it's important, I'd suggest you get it rewritten by a consultant.