chaida Posted July 23, 2009 Share Posted July 23, 2009 Hi, I'm pretty new to autoIt, so I would like to know if there is a way to open and edit an excel template (XST)? When I try to open my XST, it juste create a new instance of the template. In vba, I have to set the parameter editable to true so I can open it. With AutoIt I try this: $excel = ObjCreate("Excel.Application") $excel.visible = true $excel.Workbooks.Open("C:\test.xst") I don't know how to add my optionnal parameters without adding 8 others optionnal parameter. http://msdn.microsoft.com/en-us/library/microsoft.office.interop.excel.workbooks.open(office.11).aspx Thank you chaida Link to comment Share on other sites More sharing options...
ThomasQ Posted July 23, 2009 Share Posted July 23, 2009 I'm fairly new to, but this afternoon I used this code to open a normal excel XLS file: #include <excel.au3> $oExcel = _ExcelBookOpen("C:\temp\TestSheet.xls",1,False) This opens it Visible & Editable! Link to comment Share on other sites More sharing options...
chaida Posted July 24, 2009 Author Share Posted July 24, 2009 I see but the problem it's the template that I want to edit, I'm afraid that it will just create an instance of the template with this line of code.Thank you for helpingChaidaI'm fairly new to, but this afternoon I used this code to open a normal excel XLS file:#include <excel.au3>$oExcel = _ExcelBookOpen("C:\temp\TestSheet.xls",1,False) This opens it Visible & Editable! Link to comment Share on other sites More sharing options...
water Posted July 24, 2009 Share Posted July 24, 2009 I haven't tried it myself but I think the Excel UDF can cope with templates. _ExcelBookSaveAs allows you to save the sheet as template. I would try _ExcelBookOpen, do my changes and use _ExcelBookSave to save the template. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now