excel_macro
 

I want to write a macro that will save the current sheet as an .mdi to a
specific directory with a specific name. The macro must be able to create an
..mdi for each sheet in the workbook and save it with a different name to the
same folder without the user having to enter in the name and save the file
manually.