How To Use Python Win32com To Save As Excel File

I have a small python code to open an Excel file. Now I want to 'Save As' with a different name but same format. How do I do that.. Any help will be great. FK

Solution 1:

Just use \\ instead of /

import win32com.client 

office = win32com.client.Dispatch("Excel.Application") 
wb = office.Workbooks.Open("C:/FileName.xlsx") 
wb.SaveAs(Filename:="C:\\NewFileName.xlsx")
wb.Close()
office.Quit()