need some help automating an excel routine
can use a bit of help here.
I need to automate the following excel routine;
select file 1 sheet 1
copy cells a1 through y1 and down through a1 to a26
select file 2 sheet 1
paste at cell a1
select "view"
run macro x
It would helpful if the routine uses access
to some extent I may need to edit the routine.
I have perhaps hundreds if not thousand of files to work on.
I do have a background using dbase 5 many years ago, so I'm sure I can work with the supplied routine.
my fingers thank you, my brain thanks you and my waking and sleeping hours thank you
__________________
Peace on earth, good will to all
GOD BLESS AMERICA
" I pass with relief from the tossing sea of cause and theory to the firm ground of result and fact"
Winston Churchill
|