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.

S_Leonardo's avatar
S_Leonardo
Occasional Contributor
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
    9 years ago

    Hi S_Leonardo,

     

    Many thanks for that bit of advice.

    It proved very useful as I can now save the worksheet and move on :-)

     

    I guess there is still an issue with TC not being able to focus beyond the initial child window class, however.

     

    Cheers,

    Steve.