Hi all,
I was wondering if someone could kindly help me with a code to open a listen of files listed in a column. Let's say A5 and downwards.
Number of files can change, however once the macro opens all the files I have a message box at the end telling me what files opened.
Equally if that file doesn't exists, can the macro carry on, but at the end give me a list of filenames that did open and didn't?
Thanks
I was wondering if someone could kindly help me with a code to open a listen of files listed in a column. Let's say A5 and downwards.
Number of files can change, however once the macro opens all the files I have a message box at the end telling me what files opened.
Equally if that file doesn't exists, can the macro carry on, but at the end give me a list of filenames that did open and didn't?
Thanks