Convert 2003 Macro To 2007

**cyildirim** · 09-10-2008, 01:47 AM

Please Login or Register  to view this content.

is it possible to convert this macro to excel2007 .?

**royUK** · 09-10-2008, 04:04 AM

Have you tried in Excel 2007?

**cyildirim** · 09-10-2008, 04:50 AM

yes, if you save as 2003 format it works, but i have column problem (not enough). i haveto save it as 2007 workbook format.

**Andy Pope** · 09-10-2008, 05:25 AM

So after you save the workbook as .xlsm format does the code not work?

We need more detail.

**royUK** · 09-10-2008, 05:31 AM

So you are saying that you need more columns than Excel 2003 provides?

**cyildirim** · 09-10-2008, 07:59 AM

i cant use it with xlsm format. and i need to convert it to 2007.

im sorry i need more lines than 2003 provides

**Andy Pope** · 09-10-2008, 08:09 AM

In order to have code in a 2007 workbook you need to save it with the xlsm format. If you try to save as .xlsx the code will be removed.