Get data from closed workbook for use in a variable (no copying)
All the threads on this subject are about copying data from a closed workbook
to an active workbook. What I would like to do is just pickup the value of a
specific cell in a specific sheet in a closed workbook and use that value in
a variable for processing purposes. What can I use to do this?
Thanks
Bob
|