non standard text import

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • FloridaBlueJay
    New Member
    • Jul 2016
    • 9

    #16
    The output has a ".qan". It is a simple to change to ".txt" and import.

    Comment

    • zmbd
      Recognized Expert Moderator Expert
      • Mar 2012
      • 5501

      #17
      I have used the file dialog box with the multi-select set to true to import multiple text files.

      You can then use the With...End construct with the file-picker dialog, with multi-select set to true, to iterate thru the selected files. You could use the Name() Statement (Syntax) to rename the file to the *.txt extension then, within the With...End loop, use my sub as a function, passing to it the new file name, returning at least true/false for if the file imports without error.

      :)

      Comment

      • FloridaBlueJay
        New Member
        • Jul 2016
        • 9

        #18
        I'll take a look at that. I have a task that runs every time an output is detected and changes to .txt. A second check is run to see if it has been processed and if so, it is renamed to allow for the next output. I am working on using date/time stamp to allow for several to be in a "que" to be processed. We have a small lab and it is not an issue now but I am trying to plan for the future. I would like to thank you for all your ideas /help.

        Comment

        Working...