My current script tells it to save as the current extension xlsm that includes script. I do not want it to save as xlsm but as xlsx. How do I go about doing that?
Would it be under
I'm a noob so don't know what to modify. Every time I modify something, errors pop up. Thanks for your help.
Would it be under
VBA Code:
SaveAs TempFilePath & TempFileName &FileExtStr, FileFormat:=FileFormatNum
I'm a noob so don't know what to modify. Every time I modify something, errors pop up. Thanks for your help.