Jump to content
Sign in to follow this  
chaida

Excel and opening an XST

Recommended Posts

chaida

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
ThomasQ

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
chaida

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
water

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 (2018-06-01 - Version 1.4.9.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2018-09-01 - Version 1.3.4.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
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  

×