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.
Thanks
Please Login or Register to view this content.
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)?
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).Originally Posted by walid66
This code should do what you want more efficiently without selecting ranges.
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks