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?

Some videos you may like

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
  •