Excel : save as the open sheet

[ed973]

I really don't understand how to save as an open excel sheet.

I run a script that at the end open the excel: just only need to save as the opened excel on my desktop (and overwrite it everytime).

I'm trying to use .ActiveWorkBook.SaveAs("C:\Users\Enrico\Desktop\impegnato.xlsx") but...

 

Thanks in advance for helping.

[Subz]

Why not use Waters Excel UDF included with Autoit

[ed973]

Like?

I can send F12 (save as in excel) but then I need to change path with mouse move, etc.

 

Edited November 20, 2018 by ed973

[Subz]

I mean look in the help file for _Excel_BookSave and/or _Excel_BookSaveAs

[ed973]

Already tried but can't understand how to define the current open excel sheet. 

With the excel I want to save as open try to:

#include <Excel.au3>
_Excel_BookSaveAs("C:\Users\home\Desktop\tosend.xlsx",True)

nothing happen.

 

Thanks

[JLogan3o13]

@ed973 show your entire code, please, rather than one line and asking us to guess. 

[ed973]

 

#cs ----------------------------------------------------------------------------

 AutoIt Version: 3.3.14.5
 Author:         myName

 Script Function:
    Template AutoIt script.

#ce ----------------------------------------------------------------------------

; Script Start - Add your code below here
#include <AutoItConstants.au3>
#include <Excel.au3>


WinActivate("0a32d70a-247f-44d3-a0c8-9e649abd94a6.xlsx - Excel")
_Excel_BookSaveAs("C:\Users\home\Desktop\tosend.xlsx",True)

for sure I'm missing something

[Subz]

You're not using _Excel_BookSaveAs correctly and you need to connect to the object, so use _Excel_BookAttach

[ed973]

Thanks, but can't sort it out.

How to connect to the current open excel sheet?

 

[Juvigy]

Did you check the help file? Here is what is written there, try it :

 

#include <Excel.au3>
#include <MsgBoxConstants.au3>

; Create application object and open an example workbook
Local $oExcel = _Excel_Open()
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookSaveAs Example", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
Local $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\Extras\_Excel1.xls")
If @error Then
    MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookSaveAs Example", "Error opening workbook '" & @ScriptDir & "\Extras\_Excel1.xls'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
    _Excel_Close($oExcel)
    Exit
EndIf

; *****************************************************************************
; Save the workbook (xls) in another format (html) to another directory and
; overwrite an existing version
; *****************************************************************************
Local $sWorkbook = @TempDir & "\_Excel1.html"
_Excel_BookSaveAs($oWorkbook, $sWorkbook, $xlHtml, True)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookSaveAs Example 1", "Error saving workbook to '" & $sWorkbook & "'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)
MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_BookSaveAs Example 1", "Workbook successfully saved as '" & $sWorkbook & "'.")
ShellExecute($sWorkbook)

 

[water]

20 hours ago, ed973 said:

How to connect to the current open excel sheet?

Dog ate your help file?
The function is named something like "attach"