I am using this code to ask the user which text file to open:
[VBA]If Not Application.Dialogs(xlDialogImportTextFile).Show Then[/VBA]
the name and the place will always be different but the column widths will always be the same. I want to change that code to always have the same column widths. The only line I need to set is 49. Also is it possible it to be coded that after the user choses which text file to import, it doesn't show the text file import dialog at all?