Forum Discussion

steve_clarke's avatar
steve_clarke
Contributor
9 years ago

NetUIHWND issues - Saving an Excel worbook

I have a test, for a Delphi application, that invokes Excel in order to save a report created in the application. Excel is closed and then the workbook should be saved, with a prescribed title, to a...
  • S_Leonardo's avatar
    S_Leonardo
    9 years ago

    Have you tried to use the buttons shortcuts ?

     

    Something like this:

     

    Sys.Process('excel').Window('NUIDialog', 'Microsoft Excel', 1).Window('NetUIHWND', '', 1).SetFocus

    Sys.Desktop.Keys('~S')

     

    This will enters 'ALT + S' (Save) into the control with focus. Or just the second line if the window is already focused.

steve_clarke's avatar
steve_clarke
Contributor

Hi Marsha_R,

 

Thanks for the reply.

It's pretty much as described above. Firstly, here is the full name for the parent window:

Sys.Process('excel').Window('NUIDialog', 'Microsoft Excel', 1)

 

And now, the full name for the child:

Sys.Process('excel').Window('NUIDialog', 'Microsoft Excel', 1).Window('NetUIHWND', '', 1)

 

The actual window appears as per the attachment.

 

Cheers,

Steve.

 

Marsha_R's avatar
Marsha_R
Moderator
9 years ago

Okay, next, is the button or either of those windows in your name mapping?

  • steve_clarke's avatar
    steve_clarke
    Contributor
    9 years ago

    The name mapping is as follows:

     

    Sys-Excel-wndNUIDialog-NetUIHWND.

    Both items have the 'Extended Find box checked.

     

    Cheers,

    Steve.