Sign in to follow this  
Followers 0
Scanzee

Excel

9 posts in this topic

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>

Share this post


Link to post
Share on other sites



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

That will be a step forwards.

Scanzee

Share this post


Link to post
Share on other sites

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... B)

Share this post


Link to post
Share on other sites

#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

Share this post


Link to post
Share on other sites

#5 ·  Posted (edited)

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 by randallc

Share this post


Link to post
Share on other sites

Even that doesn't work..:s

Share this post


Link to post
Share on other sites

#7 ·  Posted (edited)

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 by randallc

Share this post


Link to post
Share on other sites

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..B)

Please help me

Share this post


Link to post
Share on other sites

#9 ·  Posted (edited)

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 by randallc

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  
Followers 0