View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Debbie Debbie is offline
external usenet poster
 
Posts: 90
Default Add a input box to ask for a filename to macro

I am trying to build into a macro I have designed, a prompt for a filename
(*.txt) that will then open the file and then prompt and open another text
file with a different end. I need to compare the first 7 characters of the
names and make sure they match before copying from one to the other and
exporting to a third. I have accomplished this with direct filenames and now
I need to back it out to ask for the files and do the comparison before
proceeding.
Can anyone help?
I have programmed before, but it has been awhile.

Thanks,
Debbie