SaveAs("testing.xlsm") wont be accepted

[lezawang]

Hi
I opened a new excel file and wrote the code below. When I ran the code, excel give me this message:
"the following feature couldn't be saved in macro-free workbooks.. to save click no ..."

https://www.dummies.com/wp-content/uploads/215281.image0.jpg

Why I got that message. If you see the code I am SavingAs ("testing.xlsm") .. the file extension has m (for macro)?
but anyway, if I click yes or no to that message, it wont save!! Thank you.

++++
Sub newone()
ThisWorkbook.SaveAs ("testing.xlsm")
End Sub

 

[Michael M]

You need to seperate the filename from the file extension !

Sub newone()
ThisWorkbook.SaveAs Filename:="Testing" & ".xlsm"
End Sub

 

[lezawang]

Thanks for your reply. Sorry what := does it do? is it part of the FileName synatax. I once somehow managed to run my code without doing the FileName stuff. Not sure why this time is not running. Thank you once again

 

[footoo]

If the workbook has not been saved before, you need to specify the path. For example :

ThisWorkbook.SaveAs Filename:="D:\Documents\Testing.xlsm"

 

[Peter_SSs]

If saving a file with macros, you may also need to specify the FileFormat. Do some research on the SaveAs method, here for example.

 

[lezawang]

Hello all, I just saved a new workbook and then run my code and it did work. So it does work if the file is not save the first time, not sure why? Thank you.

Sub newone()
ThisWorkbook.SaveAs ("testing.xlsm")
End Sub

 

[RoryA]

As Peter said, you need to specify the fileformat argument.

 

[Peter_SSs]

I just saved a new workbook and then run my code..

So it does work if the file is not save the first time

The second statement doesn't seem to follow from the first since you said you did save the workbook before running the code.

 

[lezawang]

Sorry, I meant I save the file manually by going to file-->save then changed the extension to xlsm (select macro) and then went to run my code.
Thanks

The second statement doesn't seem to follow from the first since you said you did save the workbook before running the code.

 

[MARK858]

As both Peter and Rory have stated you need to specify the file format. Please read/reread the link Peter posted in post number 5.