Need a Macro that can paste text from one workbook into any open workbook

**bachmap** · 12-29-2017, 01:59 PM

Hello,

I apologize if this is not something that is possible as I am new to Excel Macros.

My question/issue. On a monthly basis I have a disclaimer that needs to be added to recently downloaded workbooks (28 in total). Currently, I have to open up each workbook, copy the disclaimer from a separate workbook, and then "Right Click>Insert Copied Cells>Shift Cells Down>Save Workbook".

When I attempt to create a macro that does this automatically, it always references the workbook which I created the Macro in, as opposed to the current workbook I have open.

Is there a way to reference whatever workbook I have open?

Sorry if the post is long, Thank you!

**Zer0Cool** · 12-29-2017, 02:16 PM

ActiveWorkbook is the keyword for whichever workbook is currently "active" or at the forefront of your screen. ActiveSheet can be used for the sheet in the active workbook that has focus.

Are these 28 workbooks always in the same folder together? Are they the only files in said folder?

Is the disclaimer always the exact same?

Does the disclaimer always go in the same place in each workbook?

I ask due to the following:

If the files are in a folder of their own, IE folder with only those 28 files, then you could create a loop that opens each file in that folder, inserts your disclaimer and closes the 28 files fairly easily/quickly. If the disclaimer is always the same you could simply store it as a constant in a macro and "copy" it from the constant to each file. If it goes in the same place in each file that really makes it simple.

If you could provide sample(s) including a couple samples (2-4 files?) of the 28 files, the disclaimer text (doesnt have to be exact, but similar to what you want), any code you already have and maybe a sample of what finished output would look like we could work something out to accomplish what you want.

**bachmap** · 12-29-2017, 02:40 PM

Wow, that would save me so much time! The team has been doing this 1 file at a time for years and I just started 2 weeks ago. This would be great!

I have attached some images that will hopefully clarify.

1. Yes, all 28 files are kept in the same folder.
2. Yes, the disclaimer is the same every time I add it.
3. Yes, the disclaimer is added onto the same sheet for each workbook, into cell A1.
4. I forgot to add, They are the only workbooks in the folder.

Image 2 is the disclaimer. I need to add cell range (A1:L15) to cell A1 of the top workbook

Image 3 is my attempt at the macro. As you can see the error is that it is referencing a book that is no longer open. However I want it to run the macro in the currently open workbook.

1.
Excel Help.JPG
2.
Excel Help 02.JPG
3.
Attempted Macro.JPG