Rigest Posted November 12, 2010 Posted November 12, 2010 So all of a sudden all my AutoIT script arn't working anymore. In each script I get an error that some functions are missing the Endfunc statement (which isn't true). Sometimes they even say there are errors in UDF (in which I havn't changed anything): C:\Program Files\AutoIt3\Include\Excel.au3 (144) : ==> "Func" statement has no matching "EndFunc".: Func _ExcelBookNew($fVisible = 1) N:\Auto IT\Scripts\Scripts in progress\klantenservice v1.6.au3 (19) : ==> "Func" statement has no matching "EndFunc".: Func GUI() I really have no clue what I did wrong. I didn't install anything new or did anything weird.... anyone ever experienced something like this? How can I fix it?
water Posted November 12, 2010 Posted November 12, 2010 Can you post the klantenservice v1.6.au3 so we can have a look at it? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
jvanegmond Posted November 12, 2010 Posted November 12, 2010 This problem: C:\Program Files\AutoIt3\Include\Excel.au3 (144) : ==> "Func" statement has no matching "EndFunc".: Func _ExcelBookNew($fVisible = 1) Seems to be caused like a bad install of AutoIt or something similar. That.. Or you're declaring functions (partly) before you do includes? Like this (in error): Func HowDidThisGetHereIAmNotGoodWithComputer() #include <Excel.au3> I think that can cause the same problem. github.com/jvanegmond
Rigest Posted November 12, 2010 Author Posted November 12, 2010 (edited) Tnx. Edited July 28, 2011 by Rigest
water Posted November 12, 2010 Posted November 12, 2010 (edited) I tested your script and everything runs fine here. I think Manadar is right with the assumption that your AutoIT installation is broken. Reinstall and see what happens. Edited November 12, 2010 by water My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Rigest Posted November 12, 2010 Author Posted November 12, 2010 I tested your script and everything runs fine here.I think Manadar is right with the assumption that your AutoIT installation is broken. Reinstall and see what happens.I did. I installed it on a different pc and tried it on another user account. I don't think it's the installation because it worked fine before... :s
water Posted November 12, 2010 Posted November 12, 2010 Next thing I would do is check the include files.Go to the C:\Program Files\AutoIt3\Include AND the directory where your script is stored and sort the *.au3 files by date. Any files changed lately?The only files I couldn't find on my system where Outlook.au3 and Santander UDF v1.0.au3. So I created some dummy functions.Open this two UDFs in SciTE and run the Syntax Check (Ctrl+F5)As UDFs can include UDFs the problem might be with a nested UDF. So be sure to check all UDFs you've changed lately. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
Rigest Posted November 12, 2010 Author Posted November 12, 2010 Tnx Water, you helped me once again ! Apparently someone else was messing around in one of my UDF's. Luckily I had a backup. Cheers!
water Posted November 12, 2010 Posted November 12, 2010 Glad the problem could be solved! Have a nice weekend! My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
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