Create a named range in Excel

[apoliemans]

Hi,

Having problems creating a named range in Excel.

What is the autoit equivalent of this VBS code:

ActiveWorkbook.Names.Add Name:="tempRange", RefersTo:="=Sheet1!$A$1:$D$3"

Thanks, Andre

[water]

Welcome to AutoIt and the forum!

How do you open the workbook? Do you use the Excel UDF?

Edited July 19, 2013 by water

[apoliemans]

These are (some of) the statements I have at the start of my script:

$Filename = "somefile.xls"
Local $oExcelDoc = _ExcelBookOpen($Filename, 1, True)
$oExcelDoc.workbooks.add

In the active workbook I want to define a named range.

 

[water]

Try:

#include <Excel.au3>
Global $Filename = "somefile.xls"
Global $oExcelDoc = _ExcelBookOpen($Filename, 1, True)
Global $oWorkBook = $oExcelDoc.workbooks.add
$oWorkBook.Names.Add("tempRange", "=Sheet1!$A$1:$D$3")

[apoliemans]

Works, thank you!

Andre

[water]

I'm about to rewrite the Excel UDF. Do you think there should be a function to handle names of ranges (add name, list names ...)?

[apoliemans]

Right now I am quite happy with the example you gave above.

Note that I am new to Autoit (since 1 week).

My next challenge will be to create a Pivot table using this named range, I may start a new topic if I need help with that.

Andre

[water]

If you like you could have a look at the rewrite of the Excel UDF I'm working on right now.

It supports the curretn version of Excel and some functions are much faster.

Unfortunately it's still in an early Alpha state.