Pull values from a closed workbook

D

Dave L

I need to use a macro to pull values from cells in a closed workbook and i
can't seem to get it right. I basically have a variable for the directory
path and another for the file name. How do I go about getting a value from a
cell in that workbook and putting it into a predetermined cell in an open
workbook?
 

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

Formula from closed workbook? 2
Get data from closed workbook for use in a variable (no copying) 3
Arrays and scattered cell values or another way? 16
Error retrieving data from closed workbook 5
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copy sheet from closed workbook 2
READING values from a closed workbook 8
referencing a closed workbook 1

Top