There was a topic about getting data from a closed workbook aroun
friday last week and there was a link there for a code to do that bu
sorry I can't remember it so I think a search should do it.

But why not open the workbook, get the stuff you want and close it?
do it all the time (Although I am a newbie in VBA) and I see no harm i
it.

Best Regards

Noo

--
Message posted from http://www.ExcelForum.com