litlmike Posted November 18, 2015 Share Posted November 18, 2015 Any ideas on how I diagnose the issue here? Error creating the new workbook. @error =3 @extended = -214735267I can provide code, but I doubt it will do much good. Code runs in most situations, but there seems to be a random display of this error. Please advise. Local $iNumOfScienceLessonsForTheWholeSemester = 18 Local $sTabToFindEnrollmentDate = "Start Here" Local $sRangeForEnrollmentDate = "AH5" Local $sRangeForNumberofLessonsExpected_Science = "G25" Local $sDateThatMustBeMetForEnrollmentSinceDayOne = "9/1/2015" Local $sWhatQuarterTabAreWeReadingFrom = "Quarter 1" Local $sSchoolEnrollmentDate = _Excel_RangeRead($oWorkbook, $sTabToFindEnrollmentDate, $sRangeForEnrollmentDate, 3) If $sSchoolEnrollmentDate = $sDateThatMustBeMetForEnrollmentSinceDayOne Then _Excel_RangeWrite($oWorkbook, $sExcelTabForCurrentMSPR, $iNumOfScienceLessonsForTheWholeSemester, $sRangeForNumberofLessonsExpected_Science) Else Local $iCountNumOfLessons ;This means they did not enroll at the beginning of the school year, so now we have to read from the ILP how many things were assigned Local $sCellRangeColumn = "N" Local $sCellRangeBegin = "13" Local $sCellRangeEnd = "57" For $iCC = $sCellRangeBegin To $sCellRangeEnd $sIsThereTextInThere = _Excel_RangeRead($oWorkbook, $sWhatQuarterTabAreWeReadingFrom, $sCellRangeColumn & $iCC) If $sIsThereTextInThere <> "" Then $iCountNumOfLessons += 1 Next _Excel_RangeWrite($oWorkbook, $sExcelTabForCurrentMSPR, $iCountNumOfLessons, $sRangeForNumberofLessonsExpected_Science) EndIf _ArrayPermute()_ArrayUnique()Excel.au3 UDF Link to comment Share on other sites More sharing options...
litlmike Posted November 18, 2015 Author Share Posted November 18, 2015 Nevermind. It appears there was a folder causing the issue. Removed the folder and problem solved (I think). _ArrayPermute()_ArrayUnique()Excel.au3 UDF Link to comment Share on other sites More sharing options...
water Posted November 19, 2015 Share Posted November 19, 2015 You know that this errors are described in the help file?Is this error returned from _Excel_BookNew or _Excel_RangeWrite? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki 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