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

Asked By Harry D Nelson 0 points N/A Posted on - 10/23/2013

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.

• Status: Open
• Question Views: 883
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Alexander Jose

Go To Solution

Best Answer

Best Answer

Answered By Alexander Jose 0 points N/A #177236

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

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

 

About Alexander Jose

Questions
0

Answers
100

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/23/2013
• Question Category: MS Excel

Answered By Anica Macri 0 points N/A #177238

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

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.

About Anica Macri

Questions
0

Answers
101

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 10/23/2013
• Question Category: MS Excel