First of all, I want to apologize for my cross-posting. As you can realize, I'm new to all of these help forums, and apparently haven't read well the rules as needed.Originally Posted by GTO
I just saw so many people getting support while I was waiting, and that troubled me, I assume. So, again: Sorry! :]
----------
Now, mohanvijay, thanks a lot for your time and help!
Hmm, your code runs into runtime error at line 59:
That's the line:Run-time error '9':
Subscript out of range
[vba]
If cprid(final) = Workbooks("sample (1)").Sheets(1).Cells(filpr, 16).Value Then[/vba]
I have some programming knowledge, and I tried to provide a code idea above.
Since the method is supposed to write thousands of files at once, I decreased the use in loops as far as I could.
Can you or anyone else please have a look on my code?
I have no doubt it has mistakes, but I think its logic is the most efficient.
Thanks !!!