A one sheet workbook is still a workbook.
Look at "SaveAs" in Excel VBA help. The new folder has to exist...
ActiveWorkbook.SaveAs _
Filename:="C:\WINDOWS\Temp\NewFolderName\MyFileNam e", _
FileFormat:=xlWorkbookNormal
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"Matt S"
wrote in message
Thank you Jim! This worked perfectly. How do I force it to save the new
files into a new folder and convert the files to excel workbooks? Seems when
it saves the files now, they automatically save as 1-sheet files.
Thanks!
Matt