Jump to content

Manipulate print window and spreadsheet


 Share

Recommended Posts

Hi all!
 
I really don't understand much of injection and manipulating windows and such. But at the same time, it should be possible. Right?
 
First of, a spreaksheet. Much like Excel but... yeah I think you get the jist already xD I wish to insert an array into it, but I do now even know how to start doing it. This is the info provided by Au3Info:

>>>> Window <<<<
Title: Fakturering - [Faktura : (order : )]
Class: ThunderRT6MDIForm
Position: -8, -8
Size: 1936, 1056
Style: 0x17CF0000
ExStyle: 0x00040100
Handle: 0x000105AC

>>>> Control <<<<
Class: SPR32X30_SpreadSheet
Instance: 5
ClassnameNN: SPR32X30_SpreadSheet5
ID: 
Text: 
Position: 5, 187
Size: 1905, 713
ControlClick Coords: 1367, 333
Style: 0x56800000
ExStyle: 0x00000000
Handle: 0x0001066C

>>>> Mouse <<<<
Position: 1372, 562
Cursor ID: 0
Color: 0xFFFFFF

>>>> StatusBar <<<<

>>>> Visible Text <<<<
Faktura : (order : )
Permanent
Summa

 
 
 
 
Next, I am using a simple print window, where I'd like to;

  • Select printer from combo box (it has a specific name)
  • Type in text inside two different text boxes

The printer:

>>>> Window <<<<
Title: Välj skrivare
Class: ThunderRT6FormDC
Position: 453, 298
Size: 598, 292
Style: 0x14C80080
ExStyle: 0x00000101
Handle: 0x000A045C
 
>>>> Control <<<<
Class: ThunderRT6ComboBox
Instance: 6
ClassnameNN: ThunderRT6ComboBox6
ID: 12
Text: 
Position: 120, 16
Size: 201, 21
ControlClick Coords: 83, 9
Style: 0x54010243
ExStyle: 0x00000000
Handle: 0x00031152
 
>>>> Mouse <<<<
Position: 659, 348
Cursor ID: 0
Color: 0xFFFFFF
 
>>>> StatusBar <<<<
 
>>>> Visible Text <<<<
<hidden due to privacy>
Välj automatiskt
Nej
Välj automatiskt
&Ok
&Avbryt
Eposta
 
 
>>>> Hidden Text <<<<
<hidden due to privacy>

 
TextBox1:

>>>> Window <<<<
Title: Välj skrivare
Class: ThunderRT6FormDC
Position: 453, 298
Size: 598, 292
Style: 0x14C80080
ExStyle: 0x00000101
Handle: 0x000A045C
 
>>>> Control <<<<
Class: ThunderRT6TextBox
Instance: 2
ClassnameNN: ThunderRT6TextBox2
ID: 2
Text: 
Position: 408, 48
Size: 169, 25
ControlClick Coords: 78, 16
Style: 0x540100C0
ExStyle: 0x00000004
Handle: 0x00030D94
 
>>>> Mouse <<<<
Position: 942, 387
Cursor ID: 0
Color: 0xFFFFFF
 
>>>> StatusBar <<<<
 
>>>> Visible Text <<<<
<hidden due to privacy>
Välj automatiskt
Nej
Välj automatiskt
&Ok
&Avbryt
Eposta
 
 
>>>> Hidden Text <<<<
<hidden due to privacy>

 
TextBox2 is same but has instance 2 not 1.

Link to comment
Share on other sites

If it is mot Excel, which application are you talking about?

Is there a COM interface like in Excel?

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.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 (NEW 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

I'm sure the product comes with a pile of documentation. Is there something about programming? If yes, then this could be a good starting point.

Edited by water

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.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 (NEW 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

I've managed to find myself some information on the matter, thank you!

Would like a last question, about WinActive..

While 1
   If WinActive("Välj Skrivare","[CLASS:ThunderRT6FormDC]") = 1 Then MsgBox(0, "", "I can see it!")
   Sleep(10)
WEnd
Why doesn't that work, and how can I make it work?
Edited by Sodori
Link to comment
Share on other sites

Parameter 2 of WinActive only accepts text that is being displayed in the window.

Maybe you mixed parameter 1 and 2?

While 1
   If WinActive("[CLASS:ThunderRT6FormDC]", "Välj Skrivare") = 1 Then MsgBox(0, "", "I can see it!")
   Sleep(10)
WEnd

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2022-02-19 - Version 1.6.1.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 (NEW 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

Nope, still does not reveals a message box upon opening said window. You can find all it's parameters up on first post under title "The Printer:". I do not understand it.. same time I need something like it to differentiate the printing window and it's.. say child window don't know if it's the proper term but they got the same class. And atm class is the only working, "WinActive("[CLASS:ThunderRT6FormDC]")". So I somehow need to specify to the printing window and not to just any of them.

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...