Problem Copying Code

[Ipsl]

The gentleman that was so gracious as to make me some VB code is using excel 03. Im using excel 07. Is there a problem with the transfer? I cant seem to copy and paste to make it work. the first file is mine and the second file is the code.

[royUK]

I can't open 2007 in this office, where is the code?

[Ipsl]

The code in question is in the second file. Duplicate its in VB in Sheet one, this worksheet, and a module. If thats what your asking.

[royUK]

I can't see anything at the moment, I will check in 2007 when I get home.

[Ipsl]

Thanks Bro. Im at work right now and Im going to ask my IT guy when he comes in as well.... If he finds a solution I'll post it here.

[Ipsl]

Well noth the files should be in the older format. Though when I resaved it as an oldr file type I lost some of my funtionality.

Well Im going to get a little more in detail about what happens with me. So when I open the formatduplicates file it ask me if I wish to run macros. I click yes. Than I open my file press alt+F11 copy each code into the approprieate file (Sheet one, this workbork and the module) I save it on my cpu and it doesnt work. Ive saved it as a macro before and after copying the code, named the range in question as MyRange and even edited the code to a different word. Im must be doing something rong since I havent read any special copy and paste methods so Im sure it must be me.