I have a macro I use to pull data from 2 worksheets. the problem I have is that everytime I run this macro it is on 2 diff files and the file names are diff than when I originally created the macro & my macro keeps crapping out because it is looking for the original file name I used. is it possible to tweak the macro to run on any named file or do I have to rename my files everytime.
August 19, 2008 3:51 PM
September 6, 2008 10:35 PM