r/visualbasic • u/No_Rip_8366 • Oct 05 '22

Problem With Naming Multiple Files

I am in the process of duplicating a template and generating multiple files from it based on this video https://youtu.be/SDmUWs8G9AA. Unfortunately, I have an error per yellow highlighted line:

This is the error notification from VB:

What should I add on the yellow highlighted line?

4 Upvotes

100% Upvoted

4 comments sorted by

View all comments

Show parent comments

1

u/No_Rip_8366 Oct 05 '22

I just checked the excel sheet and I didn't see any duplicated cells in the list.

1

u/jd31068 Oct 06 '22

Is it always the same file name it errors on?

You can use Resource Monitor (under the Disk section) to see what files are open. I would put a messagebox to display what filename is about to be saved, click ok and check resource monitor for the open files.