acidman Posted March 14, 2012 Share Posted March 14, 2012 Hi there... How do you write data to 2 excel cells or extended the length of a cell Because when I write a numerical string Longer Than 12 characters it makes it some weird formula. any help? [u]My dream is to have a dream...[/u] Link to comment Share on other sites More sharing options...
water Posted March 14, 2012 Share Posted March 14, 2012 Weird formula? You are talking about floating point numbers. Either change the format of the cells so they are displayed as integers or enter them as text. Text means _ExcelWriteCell($oExcel, "'1234567890123456", 1, 1) 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...
acidman Posted March 14, 2012 Author Share Posted March 14, 2012 yea see I'm busy developing software so the code is a bit too huge to display as a spoiler. if I get the number from an Input box "9012494654654654" and write it tp an xls document but it gives me a weird formula when I view The xls file it doesnt display the number. [u]My dream is to have a dream...[/u] Link to comment Share on other sites More sharing options...
water Posted March 14, 2012 Share Posted March 14, 2012 Try something like this: $sInput = InputBox(....) _ExcelWriteCell($oExcel, "'" & $sInput, 1, 1) 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...
acidman Posted March 14, 2012 Author Share Posted March 14, 2012 Thanks A lot my man, I appreciate it dearly! [u]My dream is to have a dream...[/u] Link to comment Share on other sites More sharing options...
water Posted March 14, 2012 Share Posted March 14, 2012 Glad to be of service N.B. Now the cells content is handled as a string by Excel. So for later calculations you have to convert it to a number or instead of writing the number as text to Excel the formatting of the cell has to be changed. 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