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?
![Roll eyes :roll: :roll:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f644.png)
Thanks