office 2003 and office 2007

[walid66]

I recorded a code using office 2003 that deletes a row if the row starts with two letters are in the code. The code works fine on office 2003 but when I run the same code on office 2007 it won't work. Is there more efficient code that does the same thing and works on office 2007. The code is below.

Please Login or Register  to view this content.

Thanks

[Paul]

Hi Walid66,

Can you tell us at which line the code is failing? In just a quick glance, I see you're referencing a workbook name ("search_xls.xls"). When using 2007, is your file saved in the old format (.xls) or is the file saved in the new 2007 format, .xlsx (or .xlsm for macro-enabled workbooks)?

[walid66]

the file is saved in .xls format and when I run the macro it deletes everything even if the words does not starts with the letters. Should I save my macro in office 2007 format?

[royUK]

the file is saved in .xls format and when I run the macro it deletes everything even if the words does not starts with the letters. Should I save my macro in office 2007 format?

Your code works in Excel 2007. I can't see why you are saving as *.xls instead of a 2007 macro enabled workbook (*.xlsm).

This code should do what you want more efficiently without selecting ranges.

Please Login or Register  to view this content.