Hi
As usual the Excel VBA help is less than helpful!
I have a macro that opens a txt file and formats it and I want to save it as an Excel file.
The help in VBA says there is an argument type_num:
xlDialogSaveAs document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec
but I cannot find out the values that relate to this argument.
What value do I need for this argument to change it to "Microsoft Excel Workbook (*.xls)"?
Where can I find the list of values for these arguments?
Thanks
As usual the Excel VBA help is less than helpful!
I have a macro that opens a txt file and formats it and I want to save it as an Excel file.
The help in VBA says there is an argument type_num:
xlDialogSaveAs document_text, type_num, prot_pwd, backup, write_res_pwd, read_only_rec
but I cannot find out the values that relate to this argument.
What value do I need for this argument to change it to "Microsoft Excel Workbook (*.xls)"?
Where can I find the list of values for these arguments?

Thanks