How to copy a range to a closed workbook

  • Thread starter Thread starter max
  • Start date Start date
M

max

Hi

Which is the syntax to copy a range from the open and active workbook
to a closed workbook (file)?

Regards.

Massimo
Bye
 
Hi
you have to open this other workbook within your code. You
may set
application.screenupdating=false
to prevent showing this other workbook to the user
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference named range in closed workbook 23
Open four Wbooks, copy four columns from each to Master Wbook 16
Save As and new workbook new name used in existing code 8
Scattered array cells copy to scattered array cells another workbook 14
How to reference a cell from anther workbook without opening it 0
Copy from Excel to Word 2
Import multiple workbooks to current workbook in specified row number 0
closing another file by code causes failure to run workbook activate event 2

Back
Top