Can any one edit the code below so I do not get the following errors
- This extension cannot be used with the selected file type. The the file extension in the file name text box or select a different file type by changing the Save as type.
I have changed the extension from .xlsm to xlsx - when I do this I get the following error
Method save as object '_workbook' failed
I am trying to achieve the output outlined in the question link below.
' deletecolumns Macro
ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\" & "member database.xlsm"
Res = InputBox("Enter E-mail")