Jump to content

Excel - Save Workbook As question


Recommended Posts

My program asks you to open a UnitTest.xlsx, then it creates a new workbook, resorts the data from the first workbook into the second workbook. Once its done, I want the program to save the second workbook in the same directory as the first workbook was opened. 

This is the open code:

; Create application object
    $oExcel = _Excel_Open()
    If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel Error", "Error creating the Excel application object." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

    ; Open an existing workbook and return its object identifier.
    $FileOpen = FileOpenDialog("Unit Test XLSX to open", @WindowsDir & "\", "All (*.*)")
    $sWorkbook = $FileOpen
    $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook)

    GUICtrlSetData($File, $FileOpen, "")

    _GUICtrlRichEdit_SetCharColor($g_hRichEdit, 0x99)
    _GUICtrlRichEdit_ChangeFontSize($g_hRichEdit, 4)
    _GUICtrlRichEdit_AppendText($g_hRichEdit, "You Chose: " & $sWorkbook & @CRLF & @CRLF)

Would I use the $FileOpen as the _Excel_BookSaveAs file path but change the "ALL(*.*)" to the new file name? 

Link to comment
Share on other sites

What does

ConsoleWrite($oWorkbook.Path & @CRLF)

return?

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...