Excel automation

[santo]

Hi,

I use this code for values into an excel sheet Excel1

$san.ActiveWorkBook.ActiveSheet.Cells(1,1).Value="test"

$san.ActiveWorkBook.ActiveSheet.Cells(1,2).Value="test"

$san.ActiveWorkBook.ActiveSheet.Cells(1,3).Value="test"

$san.ActiveWorkBook.ActiveSheet.Cells(2,1).Value="test"

$san.ActiveWorkBook.ActiveSheet.Cells(2,2).Value="test"

$san.ActiveWorkBook.ActiveSheet.Cells(2,3).Value="test"

How can i read this values from excel1 and write it into Excel2(another excel file)

Edited December 22, 2011 by santo

[water]

Welcome to AutoIt and the forum!

Have you seen the Excel UDF (User Defined Functions) in the help file (Section: User Defined Function Reference)?

This UDF should have everything you need.