New problem! I'm trying to build an array that stores a variable each time a loop is done in a recordset. The variable is a file path that is built based on a piece of data from the recordset. How would I make sure the code adds each new variable as the code loops, instead of creating a new array each time? My thought so far is but I know it isn't quite there yet:
Code:
'Below is just an example path
Do While Not rs.EOF
.AddNew
ePath = "C:\Users\users\" & rs1.fields("Mgr ID") & ".xlsx"
.Update
rs.Movenext
Loop