Not able to convert XLS file to XLSM file in Excel 2013

Asked By 0 points N/A Posted on -
qa-featured

Hi Experts,

I have recently installed EXCEL 2013. I am not able to convert XLS file which contains Macros to XLSM file. When I am trying to save through ‘Save As’ option it is not saving the file. The file still remain in XLS format. Even after I have changed the name no new file is creating in XLSM format.

I don’t know what is the problem with it.

Can anybody gone through these type of problem.

Please help me.

SHARE
Best Answer by Alexander Jose
Best Answer
Best Answer
Answered By 0 points N/A #177236

Not able to convert XLS file to XLSM file in Excel 2013

qa-featured

The only solution to your problem is to run the macro below, to convert XLS files to XLSM files, which has been tested and verified by many users.

 

 

Sub TrandformAllXLSFilesToXLSM()

Dim myPath As String

myPath = "C:Excel"
WorkFile = Dir(myPath & "*.xls")

Do While WorkFile <> ""
If Right(WorkFile, 4) <> "xlsm" Then
Workbooks.Open FileName:=myPath & WorkFile
ActiveWorkbook.SaveAs FileName:= _
myPath & WorkFile & "m", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
ActiveWorkbook.Close
End If
WorkFile = Dir()
Loop
End Sub

 

Answered By 0 points N/A #177238

Not able to convert XLS file to XLSM file in Excel 2013

qa-featured

Hi Harry

I recommend you to visit this link  zamzar converter, it is an online file converter that lets you convert different kinds of file.

XLS to XLSM or vise versa. You just choose the file you want to convert then choose the format you want the file to be converted type your email then the converted documents will be sent to your email.

Login/Register to Answer

Related Questions