automating opening files
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: automating opening files

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Jason in Boston MA
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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?



  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi ecoscientist

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



  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Jason in Boston MA
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com