Hi,
I am trying to write a Macro that will alow me to choose a text file to important but bypass the Import Text Wizard when doing so. I used the record macro function to get this code:
The thing that I cannot figure out is what code to add (and where to add it/replace existing code) so that I am prompted to choose the file upon running the Macro (Now it is just finding the file I looked for when I specified it). I think that if I am able to do this the rest should run smoothly and import with the desired settings without the hassle of going through the Wizard. Any ideas?
Also, on a similar note. Im not sure if this is possible but I was wondering if there was a way to have the filename of the imported txt file (After it has been selected) inserted into a cell in the spreadsheet.
Thanks in advance,
Brian
Bookmarks