Give this link a try:

ยป Getting Values From A Closed Workbook using VBA in Microsoft Excel

https://www.exceltip.com/st/Getting_...Excel/357.html


--
Mark Ivey
"Jim Burke in Novi" <JimBurkeinNovi@discussions.microsoft.com> wrote in message news:94E8FB39-65F5-4FA5-BEA1-731202D89FCA@microsoft.com...
I need to reference cells from another workbook in VBA code. I don't want to
open the workbook, just reference the data from it. Any help is greatly
appreciated. Thanks.

Jim B