Sign in to follow this  
Followers 0
chaida

Excel and opening an XST

4 posts in this topic

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

Share this post


Link to post
Share on other sites



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!

Share this post


Link to post
Share on other sites

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 helping

Chaida

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!

Share this post


Link to post
Share on other sites

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 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0