I am looking for a method of opening multiple tesxt files, copying some specific data, entering it into a summary file, closing the original text file and saving the summary sheet and closing.
I can do this with a macro on 1 file at a time. I have minimal VBA for Excel background and know enough to be dangerous.
I am not sure if I need to use a form or a dialog box.
Any help would be appreciated.
Thanks
Jim
I can do this with a macro on 1 file at a time. I have minimal VBA for Excel background and know enough to be dangerous.
I am not sure if I need to use a form or a dialog box.
Any help would be appreciated.
Thanks
Jim