gunesonline Posted May 22, 2016 Share Posted May 22, 2016 #include <File.au3> #include <Excel.au3> #include <Array.au3> $ID = "charid" $pw = "charpw" $sFilePath1 = @ScriptDir & "\Kaydedilcek-excel-dosyasi.xls" If FileExists($sFilePath1) = 0 Then $oExcel = _ExcelBookNew(1) _ExcelBookSaveAs($oExcel, @ScriptDir & "\Kaydedilcek-excel-dosyasi.xls", "xls") Global $aLastRow = $oExcel.Cells.SpecialCells($xlCellTypeLastCell).Row Else $oExcel = $sFilePath1 $oExcel = _ExcelBookOpen($oExcel, 1) Global $aLastRow = $oExcel.Cells.SpecialCells($xlCellTypeLastCell).Row EndIf _ExcelWriteCell($oExcel, $ID, $aLastRow + 1, 1) _ExcelWriteCell($oExcel, $pw, $aLastRow + 2, 1) _ExcelBookClose($oExcel, 1, 0) Link to comment Share on other sites More sharing options...
gunesonline Posted May 22, 2016 Author Share Posted May 22, 2016 C:\Users\Cihan\Desktop\SteamAccountCreator-master\excelsave.au3"(11,79) : error: _ExcelBookSaveAs(): undefined function. _ExcelBookSaveAs($oExcel, @ScriptDir & "\Kaydedilcek-excel-dosyasi.xls", "xls") Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted May 22, 2016 Moderators Share Posted May 22, 2016 gunesonline, Welcome to the AutoIt forum. But please pay attention to where you post - the "Developer General Discussion" section where you started this thread is not for general support questions. I have moved it for you, but would ask you to be more careful in future. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
water Posted May 22, 2016 Share Posted May 22, 2016 Which version of AutoIt do you run? 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 Link to comment Share on other sites More sharing options...
water Posted May 22, 2016 Share Posted May 22, 2016 BTW: When posting code please use code tags (the "<>" icon in the editor). That makes the code much easier to read. 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 Link to comment Share on other sites More sharing options...
gunesonline Posted May 22, 2016 Author Share Posted May 22, 2016 1 hour ago, water said: BTW: When posting code please use code tags (the "<>" icon in the editor). That makes the code much easier to read. I do not use the latest version Link to comment Share on other sites More sharing options...
gunesonline Posted May 22, 2016 Author Share Posted May 22, 2016 (edited) #include <File.au3> #include <Excel.au3> #include <Array.au3> $ID = "charid" $pw = "charpw" $sFilePath1 = @ScriptDir & "\test.xls" If FileExists($sFilePath1) = 0 Then $oExcel = _ExcelBookNew(1) _ExcelBookSaveAs($oExcel, @ScriptDir & "\test.xls", "xls") Global $aLastRow = $oExcel.Cells.SpecialCells($xlCellTypeLastCell).Row Else $oExcel = $sFilePath1 $oExcel = _ExcelBookOpen($oExcel, 1) Global $aLastRow = $oExcel.Cells.SpecialCells($xlCellTypeLastCell).Row EndIf _ExcelWriteCell($oExcel, $ID, $aLastRow + 1, 1) _ExcelWriteCell($oExcel, $pw, $aLastRow + 2, 1) _ExcelBookClose($oExcel, 1, 0) test.au3 Edited May 22, 2016 by gunesonline Link to comment Share on other sites More sharing options...
gunesonline Posted May 22, 2016 Author Share Posted May 22, 2016 Please adaptable to new version Link to comment Share on other sites More sharing options...
water Posted May 22, 2016 Share Posted May 22, 2016 24 minutes ago, gunesonline said: I do not use the latest version And the EXACT version you use is??? 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 Link to comment Share on other sites More sharing options...
Developers Jos Posted May 22, 2016 Developers Share Posted May 22, 2016 21 minutes ago, gunesonline said: Please adaptable to new version First better prove this isn't a pilot error, which likely is the case here! Jos SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted May 22, 2016 Moderators Share Posted May 22, 2016 Jos, We no longer use "pilot error" - the new term is "human factors". Or perhaps in this case we could compromise on "keyboard-chair interface". M23 Jos 1 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
gunesonline Posted May 22, 2016 Author Share Posted May 22, 2016 2 hours ago, water said: Link to comment Share on other sites More sharing options...
gunesonline Posted May 22, 2016 Author Share Posted May 22, 2016 Link to comment Share on other sites More sharing options...
water Posted May 22, 2016 Share Posted May 22, 2016 What kind of game are you trying to play with us Please answer our questions or you will have to find the solution to your problem yourself. 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 Link to comment Share on other sites More sharing options...
gunesonline Posted May 22, 2016 Author Share Posted May 22, 2016 (edited) -snip- Edited May 22, 2016 by Jos Link to comment Share on other sites More sharing options...
gunesonline Posted May 22, 2016 Author Share Posted May 22, 2016 1 hour ago, water said: What kind of game are you trying to play with us Please answer our questions or you will have to find the solution to your problem yourself. I'm having problems while recording excel Link to comment Share on other sites More sharing options...
Developers Jos Posted May 22, 2016 Developers Share Posted May 22, 2016 1 hour ago, gunesonline said: $word = InputBox("Steam Account Creator","Kullanıcı adınızın ve mailinizin başına gelecek olan kelimeyi giriniz. " & @crlf & "Örn: techfuat -> Unfortunately you appear to have missed the Forum rules on your way in. (there is also a link link in my signature) Please read them now particularly the bit about not discussing game automation - and then you will understand why you will get no help and this thread will now be locked. Jos SciTE4AutoIt3 Full installer Download page - Beta files Read before posting How to post scriptsource Forum etiquette Forum Rules Live for the present, Dream of the future, Learn from the past. Link to comment Share on other sites More sharing options...
Recommended Posts