Hello All,

I have a macro that imports a text file, does some manipulations and, in the
end, displays the SaveAs dialog box. The default "Save as type" is "Text(Tab
Delimited)". However, the user is always going to want this changed to
"Microsoft Excel Workbook".

Does anyone know how to change the "Save as type" to be "Microsoft Excel
Workbook" using VBA?

Any help would be much appreciated.

Thanks,

Trevor