How to Maximize MS Internet Explorer Window?

[SISDTECH]

I have been testing this program and it is AWESOME!! I see so much time and labor saving by using this program.

I have read alot of post, which help me overcome issues I have encountered, but there is one issue i can't seem to figure out: "How Do I Maximize MS Internet Explorer".

When I run my web recorder IE is launched and opened. I have tried WindowAction, but can't seem to get it to work.

I have tried:

WindowAction>1,IE*
WindowAction>1,Microsoft Internet Explorer*

And no luck. I see there is something called IE_Create>0,IE[0], which I think launches IE, but I cannot find any documentation.

Any help our guidance would greatly be appreciated.

-SISDTECH

[Marcus Tettmar]

This works for me:

WindowAction>1,Windows Internet Explorer*

[DonLeverton]

This works for me:

WindowAction>1,Windows Internet Explorer*

I'm a noob, and must be doing something wrong?
Actually ... I must be doing several things wrong.
(Comments Inserted)

// Generated by MacroScript WebRecorder 4.04
// Recorded on Sunday, August 11, 2019, at 10:05 PM

//Move the mouse cursor out of harm's way to avoid causing mouseover events to interrupt
MouseMove>0,0
Let>delay=1

//Set timeout for ClickTag and FormFill to 10 seconds, increase if pages load more slowly
IESetTimeout>10,ie_res

IECreate>IE[0]

IENavigate>%IE[0]%,https://catalog.cumminsfiltration.com/catalog/,ie_res

IEWaitDocumentComplete>%IE[0]%,ie_res
WindowAction>1,Windows Internet Explorer*


IEClickTag>%IE[0]%,{""},{""},{"A"},{"TEXT"},{"Refresh the page."},ie_res

IEWaitDocumentComplete>%IE[0]%,ie_res

IEClickTag>%IE[0]%,{""},{""},{"A"},{"TEXT"},{"Part / Cross Reference Search"},ie_res

IEClickTag>%IE[0]%,{""},{"fnm"},{"INPUT"},{"ID"},{"uploadFile"},ie_res
***This works, opens a dialog box to browse for file, but I would like to just specify the file as it never changes name or location.***

IEFormFill>%IE[0]%,{""},{"fnm"},{"uploadFile"},{"C:\Users\Don\Documents\CrossToFleetguard.csv"},0,ie_res
***This was interesting, as the web recorder substituted "FakePath" between the "C:\" and "CrossToFleetguard.csv" ??? ***

IEClickTag>%IE[0]%,{""},{""},{"INPUT"},{"ID"},{"search"},ie_res

IEClickTag>%IE[0]%,{""},{""},{"SPAN"},{"CLASSNAME"},{"export_dropdown"},ie_res

[Dorian (MJT support)]

Hi Don,

Automation is like one big experiment. There are often multiple ways of doing something. You're not doing anything wrong, it's just that things don't always behave as expected. It takes experience to know which other methods to try. Here's an edit for you. It gets the Browse button and text entry working for you. I can't test more than that without a working CSV to use.

Code: Select all

//Move the mouse cursor out of harm's way to avoid causing mouseover events to interrupt
MouseMove>0,0
Let>delay=1

//Set timeout for ClickTag and FormFill to 10 seconds, increase if pages load more slowly
IESetTimeout>10,ie_res
IECreate>IE[0]
IENavigate>%IE[0]%,https://catalog.cumminsfiltration.com/catalog/,ie_res
IEWaitDocumentComplete>%IE[0]%,ie_res

//Edited this line
WindowAction>1,Internet Explorer*

IEClickTag>%IE[0]%,{""},{""},{"A"},{"TEXT"},{"Refresh the page."},ie_res
IEWaitDocumentComplete>%IE[0]%,ie_res
IEClickTag>%IE[0]%,{""},{""},{"A"},{"TEXT"},{"Part / Cross Reference Search"},ie_res

IEGetFromURL>catalog,IE[0]

//BEGIN MJT EDIT
//This seems to hang
//IEClickTag>%IE[0]%,{""},{"fnm"},{"INPUT"},{"ID"},{"uploadFile"},ie_res

//So try this instead (FindObject Wizard)
UIClick>{"Cummins Filtration - Catalog - Part Search - Internet Explorer"},{"Browse..."}
WaitWindowOpen>Choose File to*

//Send the path (Send Keys to Object Wizard)
GetWindowHandle>Choose File to Upload,hWndParent
FindObject>hWndParent,Edit,,1,hWnd,X1,Y1,X2,Y2,result
ObjectSendKeys>hWnd,{"C:\Users\Don\Documents\CrossToFleetguard.csv"}
Wait>0.1

//Click Open (ALT-O)
SetFocus>Choose File to*
WaitWindowFocused>Choose File to*
Wait>0.1
press alt
Wait>0.1
Send>O
wait>0.1
release alt
wait>0.1
WaitWindowClosed>Choose File to*
//END MJT EDIT

IEClickTag>%IE[0]%,{""},{""},{"INPUT"},{"ID"},{"search"},ie_res
IEClickTag>%IE[0]%,{""},{""},{"SPAN"},{"CLASSNAME"},{"export_dropdown"},ie_res

[DonLeverton]

Thanks, I’ll give that a try tonight.
Did you want the CSV file?
No worries about privileged information, as it’s just s list of filter numbers (generated from Access VBA) to cross-reference to Fleet guard

[Dorian (MJT support)]

If you don't have any luck, feel free to fire the list over and we'll have a play with it.

[DonLeverton]

CrossToFleetguard.csv

[DonLeverton]

I'm using MS Access to export a query as "CrossToFleetguard.csv"
The Cummins Filtration (Fleetguard) website does all of the cross-referencing programmatically, and returns the results in an Excel .XLS file named "Part Search Results.XLS".

This resulting Part Search Results.XLS file appears in the database window as a "linked table", so I will have to deal with first deleting the existing .XLS (either in Access or in Macro Scheduler) and re-creating it to avoid a copy named "Part Search Results(1).XLS" in my download directory.

Further VBA code appends the content of this linked table to a local table named "tblFilters".

I have submitted a request to have a demo on your SDK, as the thought of doing it all from with Access program, rather than "Shelling out to Macro Scheduler" appeals to me.

This is for a project for work that started out as a "hobby" ... so I will be paying for all of this myself.