To read from or write to a workbook, you must open it. You need not show it,
it can remain invisible to users, but you must open it, and close it when
done.

"Alan M" <Alan wrote in message
...
Can i use VBA toretrive data from a workbook that is currently closed and
enter the cell values specified into a range in an open workbook.worksheet
that collates information fromt he ranges in numerous closed workbooks?