svenjatzuu Posted March 13, 2017 Share Posted March 13, 2017 Hi i wrote a scanningprogram for digitalise documents last year. the prog sends the data typed in the gui inside a excel file. today i startet the prog for scanning. since it worked perfectly i didnt change anything in the code and used the program almost every day. now today i startet the prog and data was written in excel. on saving the file excel now sends error Excel UDF: Excel_RangeWrite Error writing to worksheet. @error= 3, @ extended= -2147352567 i already made systemrestoreing to frieday but still sends the same error. anyone knows what has happened and how i can solve this? Link to comment Share on other sites More sharing options...
svenjatzuu Posted March 13, 2017 Author Share Posted March 13, 2017 problem solved - external disk wasnt properly connected Link to comment Share on other sites More sharing options...
svenjatzuu Posted March 13, 2017 Author Share Posted March 13, 2017 no didnt solve the prob, was just for a moment but after reopenin the error sill is in there Link to comment Share on other sites More sharing options...
water Posted March 13, 2017 Share Posted March 13, 2017 According to the help file: 3 = $vRange is invalid. @extended is set to the COM error code Can you please post the _Excel_RangeWrite statement you run? If parameter $vRange is a variable please post the value of this variable as well. 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