iLogic GoExcel.Save

[Anonymous]

Hi All,

Could you tell me the way for "saving as" an excel file and creating a new copy from Ilogid rule, please?.

I see that exists the order "GoExcel.Save", but not "GoExcel.SaveAS".

Thanks in advance.

[MechMachineMan]

Hi. Use a combination of this call with the resources found by googling "excel + vba + msdn" and you should be able to get there.

oExcelApp = GoExcel.Application
oExcelWB = oExcelApp.Workbooks.Open("c:\file name.xlsx")
'or oExcelWB = oExcelApp.ActiveWorkbook

'Below only needed if you want to do worksheet things.
'oExcelWS = oExcelWB.Worksheets("Sheet Name")

oExcelWB.Save...

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/workbook-saveas-method-excel