pull Function

H

Harlan Grove

For anyone interested, I've updated my pull function, which may be called
from cell formulas to pull data from closed workbooks, to check for file
existence before trying to reference into files. This avoids displaying file
search dialogs when the given file doesn't exist. It's in a zipped .BAS file
at

ftp://members.aol.com/hrlngrv/pull.zip
 
F

Frank Kabel

Harlan said:
For anyone interested, I've updated my pull function, which may be
called from cell formulas to pull data from closed workbooks, to
check for file existence before trying to reference into files. This
avoids displaying file search dialogs when the given file doesn't
exist. It's in a zipped .BAS file at

ftp://members.aol.com/hrlngrv/pull.zip
Click to expand...


Hi Harlan
as always: good one!
 

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

Retain INDIRECT() Data 2
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) 0
PULL function (Harlan Grove) - can it use Named Ranges? 3
PULL FUNCTION 18
Pulling/Collating Data from Workbooks 6
Access Closed workbooks (2003) 3
Pulling data from multiple rows and columns 3
CELL("filename") acting Volatile? (in assoc. with PULL) 4

Top