i have trawl the web, and it's possible to get data from a closed workbook..but is there a way to preview a worksheet from a closed workbook? thanks for any input..