Posts by hharvey

    Re: Allow user to choose which text file to import

    Thanks mrmmickle1 - I have tried that but now I get a run time error 1004.


    I am creating a macro that allows me to import data from a text file using the Text Import Wizard and some custom fixed width column settings.
    It works great but....

    ... I would like it to pause at the 'open file' dialogue box to allow me to choose which text file to import.
    At present this macro only works for the specific text file I used to create the macro, whereas I would like to be able to choose a different text file to import in future.

    Any help much appreciated