Home > IT Answers > Development > File Name question
Estan12
5 pts.
 File Name question
Excel macros, Microsoft Excel
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.

Software/Hardware used:
ASKED: August 19, 2008  3:51 PM
UPDATED: September 6, 2008  10:35 PM
RELATED QUESTIONS
Answer Wiki:
You can ask for the filenames with an InputBox, or use Application.GetOpenFileName to select the files. If you post some of the code, maybe someone can update it for you. --JP
Last Wiki Answer Submitted:  September 6, 2008  10:35 pm  by  JP2112   475 pts.
All Answer Wiki Contributors:  JP2112   475 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _