Scanzee Posted October 29, 2005 Share Posted October 29, 2005 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> Link to comment Share on other sites More sharing options...
Scanzee Posted October 29, 2005 Author Share Posted October 29, 2005 I haven't tried anything yet. But can you explain how the #include thing works?! That will be a step forwards. Scanzee Link to comment Share on other sites More sharing options...
Confuzzled Posted October 29, 2005 Share Posted October 29, 2005 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... Link to comment Share on other sites More sharing options...
Scanzee Posted October 29, 2005 Author Share Posted October 29, 2005 #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 Link to comment Share on other sites More sharing options...
randallc Posted October 29, 2005 Share Posted October 29, 2005 (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 October 29, 2005 by randallc ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
Scanzee Posted October 29, 2005 Author Share Posted October 29, 2005 Even that doesn't work..:s Link to comment Share on other sites More sharing options...
randallc Posted October 29, 2005 Share Posted October 29, 2005 (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 October 29, 2005 by randallc ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
Scanzee Posted October 29, 2005 Author Share Posted October 29, 2005 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 Link to comment Share on other sites More sharing options...
randallc Posted October 29, 2005 Share Posted October 29, 2005 (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"; eglink below;http://www.autoitscript.com/forum/index.ph...ndpost&p=114006Best, RandallPS - 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 can1. Open the file manually.2. Open excel and the file with a "RunWait" command3. 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 ExcelCOM... AccessCom.. Word2... FileListToArrayNew...SearchMiner... Regexps...SQL...Explorer...Array2D.. _GUIListView...array problem...APITailRW Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now