I need to know how to 'default' the save file type as an .xls from a .dat
within a macro. After a macro has completed changing many .dat files into
excel spreadsheets to include subtotals, the file type is defaulted to .dat
and when I go to save the file, I have to constantly change the file type
from .dat to .xls.