xlsm SaveAs xls
Otto Moehrbach wrote:
Excel 2007 Win 7 64-bit
With VBA I'm trying to save an xlsm file as an xls file. It didn't
work. That is, after saving, the xls file does not exist and the active
file is the starting xlsm file.
I recorded a macro as I did the SaveAs and got the code (after modifying
the recorded code):
ActiveWorkbook.SaveAs Filename:= _
ThePath & "\" & WbName & ".xls", FileFormat:=xlExcel8
where WbName is "Anything".
Again, the active file is the xlsm file and the Anything.xls file does
not exist.
How do I code this? Thanks for your time. Otto
It works for me
check if ThePath & "\" & WbName & ".xls" gives you valid path and you
have access to write there.
|