VBA how to copy the selected range of data and paste into the new workbook via InputBox

**lukasz_rz** · 03-14-2014, 03:17 PM

Hello Everyone.

Let me describe the problem quickly.

Please Login or Register  to view this content.

I want to copy the data from "Data" worksheet, choose a new range in the InputBox and paste the selection there. The problem I cannot defeat is: how to choose a range in a different workbook (another Excel file opened), as I cannot do that with my macro. When the InputBox opens, I can only choose worksheets within my current excel file.

TIA for your help!

**Kaper** · 03-15-2014, 05:44 AM

Switch to other workbook before calling Inputbox. Then (if needed) return to main workbook.

PS. As a comment to other therad - while registering macro switching between workbooks is registered as Window(name).activate
As you write a macro (or edit registered one it is better to refer to collection of open Workbooks (as I shown in http://www.excelforum.com/excel-prog...ml#post3623616 )

VBA how to copy the selected range of data and paste into the new workbook via InputBox

LinkBack

Thread Tools

Rate This Thread

Display

VBA how to copy the selected range of data and paste into the new workbook via InputBox

Re: VBA how to copy the selected range of data and paste into the new workbook via InputBo

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.

Copy selected range from email attachment and paste into closed workbook

Copy selected data from two worksheets and paste it in one worksheet of same workbook

[SOLVED] Copy selected range of data and paste in new open workbook

[SOLVED] Browse a File, Copy Selected data from it and paste it to other workbook (Active)

Bookmarks

Bookmarks

Posting Permissions