I have a multiselect GetOpenFilename code that opens all files, imports and creates a tab for each opened file. Sometimes I get duplicate files, but since there can be as much as 300 files, I simply cannot "scrub" the initial list to see if there is a duplicate.
So, I need to either:
HAVE the program to skip the duplicate and continue importing rest of the files
OR
HAVE the program to list all the files and tell me to delete any duplicates
OR
HAVE the program just override the existing sheetname with the duplicate
OR
whatever you guys might think would work - I'm open to ideas.
Here is the code I use for importing the files:
Bookmarks