You might find your answer in Ron de Bruin's page. Here's the link:

www.rondebruin.nl/copy3.htm

Regards



"ChuckTX" wrote:

Is there a way to get values from closed workbooks with known file names & locations. Speaking of the locations does anyone know the system variable for the "My Documents" folder. Right now I am using ExecuteExcel4Macro. This part is wrking I was just trying to find another way to accomplish this task