I am curious about the best way to handle this. I am using access vba to open an excel workbook delete a few rows, then delete a few columns, then add some data.
so it's like a step process, each step is dependent upon the first being completed.
For example, I need this
code to complete before I call this
And once all of the garbage rows have been deleted, I then need to do further manipulation like capturing the last row etc.
With all of that said, how do I just need to call
throughout the code so that subsequent updates "see" the changes that were made earlier in the code? Or do the changes that are made take affect immediately so there is no need to call wb.Save until the process is completely finished?
so it's like a step process, each step is dependent upon the first being completed.
For example, I need this
Code:
Rows("1:2").Select
Selection.Delete Shift:=xlUp
code to complete before I call this
Code:
Rows("2:6").Select
Selection.Delete Shift:=xlUp
And once all of the garbage rows have been deleted, I then need to do further manipulation like capturing the last row etc.
With all of that said, how do I just need to call
Code:
wb.Save
throughout the code so that subsequent updates "see" the changes that were made earlier in the code? Or do the changes that are made take affect immediately so there is no need to call wb.Save until the process is completely finished?