Copy and Paste from One Workbook to Another

**rbell22** · 03-30-2021, 12:49 PM

Hello,

I need to copy cells from one workbook and paste them into a different workbook. I would prefer for the destination workbook to not have to be open when the VBA is running. If that is not possible, maybe I could included an 'open Home workbook' code in the VBA?

Attached are two sample workbooks that I am using. Home is where the information is stored and Destination is where I'd like to paste the information. The Destination file will have the pasted information organized in a row/column format.

Home has roughly 250 tabs in the actual workbook that are titled with the Company Name.

Thank You so much in advance.

Rob

**Richard Buttrey** · 03-30-2021, 01:03 PM

You will need to open the workbook to be able to do that.

I generally Dim a variable for it and also one for the current workbook so that you can jump back and forth if necessary

e.g.

Dim wbTemp As Workbook, wbMain as Workbook

Set wbMain = Thisworkbook
Set wbTemp = Workbooks.Open(Application.GetOpenFilename)

Copy and Paste from One Workbook to Another

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Copy and Paste from One Workbook to Another

Re: Copy and Paste from One Workbook to Another

Thread Information

Users Browsing this Thread

Similar Threads

Macro to: open workbook, copy multiple values, paste them to another workbook.

[SOLVED] VBA Macro pull a certain cell in closed workbook and copy/paste into current workbook

[SOLVED] Macro to find data in source workbook and copy paste to target workbook

How to copy sheet and paste it to other workbook, and automatically paste the data.

Help on VBA loop to open workbook, copy/paste to master workbook, close, and then next.

Copy and paste non consecutive cells and paste consecutively in another workbook

Simple task: Open a workbook, copy a range, paste into another workbook

Bookmarks

Bookmarks

Posting Permissions