Copying a Range from another Workbook

  • Thread starter Thread starter Ruan
  • Start date Start date
R

Ruan

Hello,

Is it possible to copy a range of cells (only the values) from a closed
Workbook?

Example:
I would like to open Workbook A and have it automatically copy the range
(A8:Z1000) from Workbook B and paste (paste special - values) it to a
specific sheet in Workbook A.

I am finding that linking to another Workbook takes up to much file size,
which reduces the performance of my excel workbook.

Thanks
Ruan
 
Hi Ruan
though this can be done using macros (which would also open the second
workbook for copying the data and closing it afterwards) I would use a
cell link 8much more reliable). Also you don't have to update the links
at startup if the other workbook is closed.
Also I doubt that the file size would differ that much.
You probably have linked all cells of a sheet to your existing
workbook. Try reducing the formulas for linking (use only your range
A8:Z1000)
 
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

Scattered array cells copy to scattered array cells another workbook 14
Cell values to an array, then array transpose to another workbook 8
VBA code for pasting links -- modifying RDB code for summary workbook 10
Save As and new workbook new name used in existing code 8
Copy Multiple Areas from One Workbook to Another 4
Import multiple workbooks to current workbook in specified row number 0
Open four Wbooks, copy four columns from each to Master Wbook 16
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top