R
robot
Hello,
I have an Excel file (FileA.xls) with a button that, when clicked, will fire
a subroutine that will:-
1. Save the file (activeworkbook) as FileB.xls (So FileA is closed
automatically)
2. Delete some rows from FileB
3. Save and Close FileB
4. Open FileA
5. Delete some other rows from FileA.
However, the code runs fine except that 5 above is not executed. I guess it
is because I have closed FileA in which the subroutine resides.
How do I solve this problem? Suggestions will be appreciated.
I have an Excel file (FileA.xls) with a button that, when clicked, will fire
a subroutine that will:-
1. Save the file (activeworkbook) as FileB.xls (So FileA is closed
automatically)
2. Delete some rows from FileB
3. Save and Close FileB
4. Open FileA
5. Delete some other rows from FileA.
However, the code runs fine except that 5 above is not executed. I guess it
is because I have closed FileA in which the subroutine resides.
How do I solve this problem? Suggestions will be appreciated.