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.

Marsha_R's avatar
Marsha_R
Moderator
9 years ago

I would expect that recording gives you coordinates, that's the usual thing.

 

If you use Object Spy on the button, what path does it give you?  Post it here please.

  • steve_clarke's avatar
    steve_clarke
    Contributor
    9 years ago

    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.