Excel

[Scanzee]

Please can someone help me.

Need to know how you do the whole thing..

Newbie in this part of autoit!!

Thanks, Scanzee Products <Scanzee@hotmail.com>

[Scanzee]

I haven't tried anything yet. But can you explain how the #include thing works?!

That will be a step forwards.

Scanzee

[Confuzzled]

I haven't tried anything yet. But can you explain how the #include thing works?!

That will be a step forwards.

Scanzee

The Help file, both for Excel and AutoIT has a lot of useful information that a number of people have devoted a great amount of time to make presentable and readable. You are kindly referred to the source of all knowledge there...

[Scanzee]

#include<ExcelCom.au3>

$sFilePath = "D:\Factuur.xls"

$sheet = "Blad3"

$Column = "10"

$Row = "C"

_ExcelCOM($sFilePath,"Blad3","F",$Row,"Write","Save","222","Visible","Exit","NOTLastRow","NOTToColumn")

-------------------------------------------------------------------------------------------------------------------------

I always get the message that he couldn't open D:\Factuur.xls as an excel file...

What the hell am I doing wrong?

Scanzee

[randallc]

hi,

Try $Row=1 [Columns accept range or letters, Rows only numbers, Sorry] and "NoExit" to start.

Sorry, too; "Write" is not valid; needs "Into" ; i must change that for consistency!

_ExcelCOM($sFilePath,1,"F",$Row,"Into","Save","333","Visible","NoExit","NOTLastRow","NOTToColumn")

or use the shorter command; [Either way you can use the sheet name OK too if youwant]

[_XLWrite($sFilePath,1,"C",1,"333",1) ]

Best, Randall

Edited October 29, 2005 by randallc

[Scanzee]

Even that doesn't work..:s

[randallc]

Have you got the Sample scripts going? - even the first "Syntax example" at the top of the page from my signature? [if not, perhaps "Beta" version not currrent? - have you v84?]

Otherwise, post your script and current error; again, let me check again?...

best, Randall

Edited October 29, 2005 by randallc

[Scanzee]

I have the beta 84

I just can open the D:\Factuur.xls as an excel file. (That is what is in the msgBox)

What version of office do you need or isn't that the problem.

I coppied a copple of scripts from the autoit forum but not one of them works.

I always get the msgbox... I become crazy from such things..

Please help me

[randallc]

Hi,

I can use back to Excel97, though then there can be trouble with saving any files made with newer versions; NOT opening them!

Perhaps try the basic commands without the include and see what happens on your computer;

or try a different "include"; eg

link below;

http://www.autoitscript.com/forum/index.ph...ndpost&p=114006

Best, Randall

PS - Unfortunately, that message is the one I get when I try to Get an Excel object on a machine without Excel installed; perhaps make sure you can

1. Open the file manually.

2. Open excel and the file with a "RunWait" command

3. Get the object with a different includeas above.

4. Try a simple line without the include, and with the file already open - eg

$oXLApp=objcreate("Excel.Application")

if not IsObj($oExcel) then MsgBox(0,"","what - no Excel!")

5. Try my vbscript to avoid AutoIt or UDF ExcelCom

6. If none open, you may need to re-install Excel?

Thanks, Randall

Edited October 30, 2005 by randallc