automating opening files

[ecoscientist]

I am setting up an automated system that will open a selected textfile, copy a specified range and paste it into a worksheet. My problem for every file selected there are 2 files with similar names that need to be accessed.
Example: 3L3001-pid.isd and 3l3001-fid.isd
the only difference between the 2 filenames will always be the p and the f in the name.
any ideas?

 

[Dave Hawley]

Hi ecoscientist

I cannot see what your problem is! Can't you just open each file by it's name?

 

[ecoscientist]

I am using a variable to identify the first file then I need to be able open the other file.

 

[Legacy 98055]

Post you code.
How are you opening the second file?