S
S Himmelrich
Basically, I'm provided with a worksheet with several sheets with a
lot of cleanup and some deletion of sheets. I must do the clean up in
Excel, no export to Access or another product then re-import. What
has been done so far is that macro's are build to perform this
funtionality. However that means you must use a template where the
macro resides.
Here are my several questions?
Is there a way to reference code or external macros to run against an
excel file? If so, where is there information on this process?
What is the best approach on this type of cleanup script or macro?
your thoughts would be appriciated on this...thx.
lot of cleanup and some deletion of sheets. I must do the clean up in
Excel, no export to Access or another product then re-import. What
has been done so far is that macro's are build to perform this
funtionality. However that means you must use a template where the
macro resides.
Here are my several questions?
Is there a way to reference code or external macros to run against an
excel file? If so, where is there information on this process?
What is the best approach on this type of cleanup script or macro?
your thoughts would be appriciated on this...thx.