I will appreciate very much if you can help me with the following
I have about 120 Excel files and one other file, let's call it the
I need to copy the contents of one cell from the Source file into each
one of the 120 files and also do the same with a text box.
It will be necessary anyways to go manually through
each of the 120
files and check them so I was trying to make a macro that will paste
into the active cell the contents of, let's say, cell B40 from the
Source file. Then I was planning to do another macro for the text box,
ie to paste in the active cell (which will be a different one) the
textbox from the Source file. (I will click manually the active cell).
Because of the two (or may be three) things
that need to be pasted in
each of the 120 files I can't just paste the clipboard.
So I was trying to do this macro using the recorder (I
about code) The problem is that it works only for the file it's
created in. If run in another file it gives an error (Runtime error 9:
Subscript out of range) and stops on the 5-th line that has the name of
the file it was created in("CO23df_pds.xls"). Here is the code:
' Macro6 Macro
' Macro recorded 6/9/2006 by LARRYB
Application.CutCopyMode = False
It looks to me it's not pasting in the currently active cell but is
trying to paste in the file it was created in.
So as I have 120 of these, my question is how to make a macro
pastes in the active cell the contents of a given cell from another
file (in my case B40 from Source file)???
Thank you in advance for all help - it is really appreciated !! Also
please explain in a simple way as I've never worked with any code...