Good day all

I need to do a macro, where the user is prompted for input, which can be any value from 1 to 50. the input must then be combined with ".xls (resulting in a filename for example 5.xls if the user entered "5" at the ptompt.) Once that is done, I need to open the files with the same names in 3 different folders (for example c:\documents\folder A, c:\documents\folder B and c:\documents\folder C).

I am not familiar enough with VBA or SQL to do this in a macro. Anyone with ideas?