values from other workbooks.

[Guest]

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

 

[Norman Jones]

Hi Chuck,

For part #2:

Application.DefaultFilePath


---
Regards,
Norman

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

 

[Guest]

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

www.rondebruin.nl/copy3.htm

Regards