values from other workbooks.

C

ChuckTX

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
 
N

Norman Jones

Hi Chuck,

For part #2:

Application.DefaultFilePath


---
Regards,
Norman

ChuckTX said:
Is there a way to get values from closed workbooks with known file names &
Click to expand...
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
 
Top