Excel COM func

[randallc]

Hi, guys,

I've had no answer to this on support; anyone here interested?

Can anyone please help with improving this script to check if it will give errors (ie wrong cell format, locked cells, read only file, etc in Excel?)

Here is simple example script;

This reads a cell in a sheet, then adds to it, then changes content, then saves and exits Excel.

Function in second section.

Is this already written well as a discrete function? -I cannot find it in search. 

Best, Randall

Here is orig example; but extra parameter added now (so file lines with tabs can be selected to go "to Columns" instead of rows if needed)

Note also automatic calc is now turned off till a "save" is performed

dim $FilePath,$var

$FilePath="c:\winword\Excel\Book1.ls"

If Not FileExists($FilePath) Or Not StringInStr($FilePath, "xls") Then

  $FilePath = FileOpenDialog("Go - Choose your excel file as inbuilt one not exists", $FilePath, "Worksheet" & " (" & "*.xls" & ")", 1);+ $Recurse+ $Recurse

EndIf

_ExcelCOM($FilePath,1,"E",7,"Read",1,4,0,0,0,0); read cell "E7"

msgbox (0,"ReadCell=",$var)

_ExcelCOM($FilePath,1,"E",7,"Add",1,9,0,0,0,0); Add 9 to cell "E7"

msgbox (0,"After Add=",$var)

_ExcelCOM($FilePath,1,"E",7,"Into",1,"Hi",1,0,0,0); write 'Hi' and make visible cell "E7"

msgbox (0,"After Into=",$var)

_ExcelCOM($FilePath,1,"E",7,"Read",1,4,0,1,0,0); read cell "E7" and Exit Excel

msgbox (0,"After Exit=",$var)

msgbox (0,"Excel Process Exists=",ProcessExists ( "Excel.exe" ) )

Exit

EDIT -updated to take tab-delimited strings (extra parameter than before for "wanting to find "lastcell"/ lastrow +1 address Edited July 30, 2005 by randallc

[DaleHohm]

I know you're frustrated that this isn't drawing much interest here, but there's good reason for it I think. The membership of this forum is 100% AutoIt, 10% COM and 1% Excel. If you were having trouble converting a working VBScript example to AutoIt you'd get a lot of help here, but what you're asking for has little to do with AutoIt and nearly everything to do with Excel.

I'd suggest you'd get a lot more interest from an Excel forum helping you with a VBScript version of this that you could later convert to AutoIt. You can find such a forum here: Microsoft Excel Community Forum

Dale