VBA Search Macro works in 2007 wont work when using 2003

I have the below code that works fine when I run it on my computer using 2007. When my associates try to run it using 2003 it doesnt work. I can't figure out what I need to change in order for it to work across the board.

here is the code:

Please Login or Register  to view this content.

END OF CODE

Essentially what it is doing is searching an excel file for a value and selecting a specific number of cells from the offset of finding that value. There are several variables that have to pull from the orignal sheet that is running the macro and I need those variable to be pull from the sheet so that I can have different values on different sheets. It works on 2007 as I said but I cant get it to work with 2003. No idea why.

I am relatively new to VBA and have worked this out based on previous forum questions and utilizing the macro recorder on 2007.

Thanks for your help.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Something like this:

Please Login or Register  to view this content.

Note: we generally need more information than "doesn't work". In what way does it fail - error message, do nothing, do the wrong thing or something else?

If the workbook is open in the same instance of Excel, then you would only get that error if the workbook name is wrong or the sheet name is.