M
Me !
I have a macro in excel that fills a form for a branch and then print it for
90 times.
I want to send them by email and for this i need to send a file to each
branch.
Instead of
Cells.select
Cells.copy
....
workbooks.add
.......
activeworkbook.save .... and so on
is there a shorter way for putting a sheet separated in another file?
90 times.
I want to send them by email and for this i need to send a file to each
branch.
Instead of
Cells.select
Cells.copy
....
workbooks.add
.......
activeworkbook.save .... and so on
is there a shorter way for putting a sheet separated in another file?