gunesonline

eror help pls

17 posts in this topic

#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)

Share this post


Link to post
Share on other sites



C:\Users\Cihan\Desktop\SteamAccountCreator-master\excelsave.au3"(11,79) : error: _ExcelBookSaveAs(): undefined function.
_ExcelBookSaveAs($oExcel, @ScriptDir & "\Kaydedilcek-excel-dosyasi.xls", "xls")

 

Share this post


Link to post
Share on other sites

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._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

Share this post


Link to post
Share on other sites

Which version of AutoIt do you run?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

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 (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

#7 ·  Posted (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 by gunesonline

Share this post


Link to post
Share on other sites

 

Please adaptable to new version

Share this post


Link to post
Share on other sites
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 (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites
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


Visit the SciTE4AutoIt3 Download page for the latest versions        Beta files                                                          Forum Rules
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Share this post


Link to post
Share on other sites

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

1 person likes this

Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

Share this post


Link to post
Share on other sites
2 hours ago, water said:

 

Share this post


Link to post
Share on other sites

:(

 

Share this post


Link to post
Share on other sites

What kind of game are you trying to play with us :huh:
Please answer our questions or you will have to find the solution to your problem yourself.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (2016-08-18 - Version 1.4.6.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2016-12-04 - Version 1.2.2.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#15 ·  Posted (edited)

-snip-

Edited by Jos

Share this post


Link to post
Share on other sites
1 hour ago, water said:

What kind of game are you trying to play with us :huh:
Please answer our questions or you will have to find the solution to your problem yourself.

 

 

I'm having problems while recording excel

Share this post


Link to post
Share on other sites
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. :naughty:

Jos


Visit the SciTE4AutoIt3 Download page for the latest versions        Beta files                                                          Forum Rules
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.