Using a macro to open a file in the "home" directory 1

[Haf]

I'm trying to write (actually record) a macro for a repetitive data reduction process. Each test dumps 8 files into a folder. The names of each file in the folder are identical from folder to folder, but the folder names are all different.

What I'd like to do is open one of the files in a given directory and then run a macro that automatically opens the other files in the directory, and then copies and pastes selected data into the originally opened file.

My problem is that when I record the macro, the VBA code refers to the entire filepath of files that I open. This is different than other codes I have worked with, which automatically open files in the directory the code is running in unless you specify otherwise. Is there a way to open files from the "home" directory, i.e., the directory in which the original file was opened?

Thanks in advance for helping a novice when it comes to Excel macros!

Haf

 

[melone]

strPath = ActiveWorkbook.Path

 

[Haf]

Thanks, melone! That's exactly what I was looking for and it works perfectly.