I have windows 8 and excel 2010 & excel 2013 on my computer.
When I run the macro recorder, It will not show a saveas code, there are other features as well that will not record.
Davesexcel has a sample video that shows the resulting code using saveas.
https://www.youtube.com/watch?v=yiLJacqh1Hs
This is the result I get when I saveas using the Macro Recorder.
![]()
Sub Macro1() ' ' Macro1 Macro ' ' End Sub
Bookmarks