Hi there. New to VBA and kind of learning as I go.
We have an Excel file that is about 60k lines long that I have figured out how to break out into different workbooks based on the value in column A. It ends up producing about 150 workbooks.
The problem is, my computer doesn't have enough memory to store all of the files open that it creates with the 62k lines and so I want to do the following:
Once a workbook is created, I want to save the file to the network drive H using the values in Column A Row 2 then Column B Row 2 then today's date.xlsx then I want to close the file so that they do not take up all of my RAM.
So for example file one would look like 1445Company1 07.27.21.xlsx and then it would save to my H drive and close.
I haven't quite found the correct combination of code to do so.
Can anyone help?