Get Values From Closed Workbook

[the blue fox] · Oct 2nd 2007

Hi all,

I have been sitting in front of the forums for a while and cant see anything that is helping.

I have a master file with two sheets. I have another input file with only one sheet.
Without opening the input file, is it possible to copy the range and paste special values only into a duplicate sheet in the master?

AAE · Oct 2nd 2007

Re: Copy Values From Unopened Workbook To An Open Workbook

Try these threads.

Grabbing Data From A Closed Workbook --http://www.ozgrid.com/forum/showthread.php?t=63063

Importing unopened worksheet into an open Workbook --http://www.ozgrid.com/forum/showthread.php?t=32820

Copy From Closed Workbook To Open Workbook --http://www.ozgrid.com/forum/showthread.php?t=67714

Extracting data from a workbook based on a lookup workbook --http://www.ozgrid.com/forum/showthread.php?t=40379

Many more posts available using these search terms: Copy from closed workbook

HTH,

AAE

**Reafidy** · Oct 2nd 2007

Re: Get Values From Closed Workbook

Check the possible answers table now I have edited your thread title.

Get Values From Closed Workbook

Participate now!

Share