I need to know how to save a new excel workbook to a location of my choosing. I want to be able to open a new workbook, add data, and then save it in a folder in my project folder. I can do everything but save it to the new location. This is what I have so far.
(vl-load-com)
(setq FilePath "T:\\reference material\\fuse_list_template.xls")
(setq ExcelApp (vlax-get-or-create-object "Excel.Application"))
(vla-put-visible ExcelApp :vlax-true)
(vlax-put-property ExcelApp "DisplayAlerts" :vlax-false)
(setq Wbk (vl-catch-all-apply 'vla-open (list (vlax-get-property ExcelApp "WorkBooks") FilePath)))
From here I am adding data from autocad electrical 2011 which works fine.
My problem is I want to save this to a location that is not the same as the original filepath.
I cannot find the code to do a "save as" to the excel workbook.
Any help would be appreciated. It should not be this complicated.
Thanks.