values from other workbooks.
 

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

values from other workbooks.
 

Hi Chuck,

For part #2:

Application.DefaultFilePath


---
Regards,
Norman

"ChuckTX" wrote in message
...
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

values from other workbooks.
 

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