automating opening files

ecoscientist · Apr 6th, 2002, 11:01 PM

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 · Apr 7th, 2002, 04:36 AM

Hi ecoscientist

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

ecoscientist · Apr 7th, 2002, 06:35 AM

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

Tom Schreiner · Apr 7th, 2002, 06:42 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 6th, 2002, 11:01 PM	#1
ecoscientist New Member Join Date: Apr 2002 Location: Jason in Boston MA Posts: 12	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?

Apr 7th, 2002, 04:36 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi ecoscientist I cannot see what your problem is! Can't you just open each file by it's name?

Apr 7th, 2002, 06:35 AM	#3
ecoscientist New Member Join Date: Apr 2002 Location: Jason in Boston MA Posts: 12	I am using a variable to identify the first file then I need to be able open the other file.

Apr 7th, 2002, 06:42 AM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Post you code. How are you opening the second file?