I have a script that opens some Excel books that are stored in SharePoint . Without getting to much into detail as its a very long story I have to open Internet Explorer to the SP site in order for all of this crap to work.
Anyway I have a bit of code in my script that i found via google-fu
$ieList = ProcessList("iexplore.exe") If IsArray($ieList) Then For $I = 1 To Ubound($ieList) -1 ProcessWaitClose($ieList[$I]) Next EndIf Exit Now on Windows 7 this bit works great. On Windows Server 2012 R2 where this things runs is another story. I need to be able to force close all instances of Internet explorer that are running as part of my code.
Any help is appreciated.
An adaption of an adaption.
A good while back, I created a program, KindEbook Wishlist, that I use most days and is still available here at the forum. It works well, keeping tabs on price changes for Kindle ebooks at Amazon ... at least for my modest wants.
About a year or so later, I struck upon the idea of adapting that program for CDs, DVDs, Blu-rays etc from the JB Hifi store, where there was a limit of about 50 items on the in-store wishlist. JB Wishlist is kind of a niche program, really only suitable for those from AUS, at the AutoIt Forum, who would want such a thing ... so not many I imagine, so it has never been available here. However, if you meet that criteria etc, and are willing to register at the AutoIt4Life Clubrooms, then it is available in the Project Chat section there ... though not the more recent updates (you need to ask me about them). That too, works quite well for my modest needs, and even includes an additional Preview & Summary window, which KindEbook Wishlist doesn't have ... though both programs do have access to a Details window per item, that is like the Preview window ... just doesn't constantly display alongside the Main program window (see later for an example with IonGoG Wishlist).
So, now we come to IonGoG Wishlist, which is an adaption of the JB Wishlist program, and used for keeping tabs on GOG Games ... prices, history of changes, bought list, etc.
IonGoG Wishlist is an incomplete adaption, so still in beta ... though all the really important elements work well enough. I have been working on it in dribs and drabs, and I now think it has come to a reasonable enough stage to share it ... just be advised, that some of the features accessed via the right-click menu etc, may not work or give strange results. Any of the options that I have given an Accelerator key facility to, should be working fine ... and most of the others are too ... and I am not even sure at this point, of what remains to be adapted ... not much I imagine.
The name by the way, in case you were wondering, is a phonetic mangling on the words - keep an Eye On your GOG Wishlist.
Here is a screenshot, with the Preview window on left. The Preview window can be placed at right instead or even turned off.
Download, includes source files.
IonGoG Wishlist v0.0_b14.zip (see detail at Post #10)
I have another program that GOG users may be interested in, that can assist with getting game images that IonGoG Wishlist gets and doesn't get ... larger versions taken from modified thumbnail links in their GOG Library.
Downloads Dropbox (see the GOG example in Post #7)
In reality, compared to most stores I have come across, the GOG store is great, well setup and laid out. and for most things, including their Wishlist, is more than adequate. So I rarely do a full list Price Query ... so much quicker and easier to just check the two pages of my in-store wishlist. When I first started work on IonGoG Wishlist, the in-store wishlist wasn't as good as it is now.
All that said, I still find it handy to use IonGoG Wishlist, for a variety of things - Offline browsing, Cover images to use with my bought & downloaded game folders, price changes history (and patterns of GOG behavior for sales etc), a bought list (with price I paid and date etc), Game Notes & Warnings, etc. And while not as quick as just checking the pages of your in-store wishlist, you can just set the full, favorites or non-favorites Query going, while you go away and do something else, and then later come back and look at the highlighted changes that may have occurred.
KindEbook Wishlist and the other programs are now being updated at a new topic - KindEbook Suite
Formerly known as KindEbook Price Query.
Please read IMPORTANT ADVICE here at Post #57. (9th May 2016)
Reading some sections of the previous topic could be helpful. There is also a Disclaimer reference etc.
Screenshots in second post.
See Post #51 for information about the Bonus program (AZWPlug).
See Post #96 for Instructions & Screenshots for Bonus program (Add Book & All Formats To Calibre).
(11-12-2017) KindEbook Wishlist updated to v5.8
Added a 'Both' option to the Search category dropdown, though it only works for selection display, plus copy to clipboard with the new clipboard button. Star button relocated to left of selection display (input) field, with the new clipboard button taking its prior location at right. NOTE - This now provides a quick easy way to copy Author &/or Title text for the selected entry, to the clipboard.
Added a 'Simple' option to the Search category dropdown, which justs finds the specified text in the chosen column (Title or Author), and selects that row. Search starts at the selected entry and will wrap around at need. The Clipboard button, can now be set in the program settings (or used with CTRL), to minimize the program window when clicked.
Moved the right-click 'Save the Ebook list to file' option to a sub-menu entry, and added a 'Save to List for Excel' option there to, which is mostly just for my specific personal use, but others might find it useful (includes SHIFT+X accelerator key usage). NOTES - This new feature assists me, when I want to add new entries to my Booklist.xls file (in batch mode). It just helps to quickly create the basic entries, which I then flesh out later at my leisure, and helps avoid a lot of repetitive clicking. Used in conjunction with my related Excel macros.
Add Book & All Formats To Calibre updated to v1.7 (NOTE - This has only been tested with calibre v2.x.x, not the newer v3.x.x.)
A bugfix for duplicate title issue - I had not realized that a failure due to a duplicate was based solely on a title match. All duplicates are now added unless an ID match occurs. VIEW button can now view a saved specified format.
(30-11-2017) KindEbook Wishlist updated to v5.5
Improved the Copy/Move input box dimensions, to more easily accommodate long titles. Mode for troubleshooting (me only) has been improved, to avoid me losing my sanity again (I'd forgotten it even existed). Replaced the (last version update) new CTRL option at program start, with a 5 second dialog prompt instead.
(11-11-2017) AZWPlug updated to v2.8
Database list can now be set not to display when starting that window, plus a LOAD button added to load that list when desired. CTRL used with the open Kindle Content folder button, will now close the program. If CTRL used when selecting the MODE on the Results window, it will just save the setting without making changes to existing results. Option added for slicker loading of list, plus alternate list lines are now pale pink. Two find options added for the Author and Title, with FIND jumping to each entry found and SHOW just displaying all found.
NOTE - With LOAD deselected, the list will only show the added ebook title (if any).
KindEbook Wishlist - Most controls get disabled now during a Query, plus the same occurs during an 'Exchange Rate Query'. Plus if 'Please Wait' splash is disabled for Query, then a splash is no longer shown during an 'Exchange Rate Query', with that text shown instead in both the 'Please Wait' and 'Timer' labels, which are temporarily unhidden for that purpose. The Timer label can also be reshown if hidden by the new feature, by clicking the FIND label.
Mouse cursor now changes during Query and Ebook list loading etc, to indicate when busy working. Extended the 'Please Wait' label to loading & sorting the Ebooks list, which also applies to any other process that re-populates or changes number of list entries (ebook removal, changing user, relocating bought, etc). Those are all dependent on the "Use a flashing 'Please Wait' ..." setting being set. NOTE - This feature was added to this and the previous version, so that having a 'Please Wait' splash displayed on top of all windows, for a lengthy period perhaps, could be avoided, if desired.
Previous Versions (newer)
Previous Versions (older)
The KindEbook Wishlist, is basically a compliment to your regular store wishlist, but has a history element and allows you to check current and previous prices etc in a better, quicker and more organized fashion. Essentially it assists and hopefully improves with decision making, when it comes to determining whether to make a purchase yet or not.
You could compare it to manually and painfully creating something like an Excel spreadsheet for the same purpose, without the time, complexity and pain involved.
You can sort by Title, Author, Current Price, Lowest Price, Add Order, Favorites, etc.
You can view details - Book Description, Price Changes, etc.
You can open the ebook URL in your web browser, where you can elect to make the purchase.
The program supports multiple users, shared titles, shared comments and private comments, etc.
After purchase, an ebook can be relocated to a bought list (per user).
Price can be queried on an individual title basis or ALL titles (starting at first or selected or only favorites or not favorites).
Dates are recorded for most processes, with various reporting options.
I call it a wishlist on steroids.
I'm struggeling with the following:
In a website I have to fill in several items. For the normal fields I am able to fill in the information by using UDF "_IEGetObjByName".
But there is also a dropdown menu and I can't figure out how to choose te right information from it. I have searched the helpfile and the forum but I can't figure it out.
Here's an excerpt from the html-page of the site where the dropdown-menu is mentioned:
<div class="col-md-10 padding-5">
<div class="btn-group m-r">
<input type="hidden" name="bedrijfId" class="bedrijfId" value="">
<button type="button" data-toggle="dropdown" class="btn btn-sm btn-default dropdown-toggle" >
<span class="dropdown-label">Choose Company</span>
<ul class="dropdown-menu dropdown-select" >
<li data-value="2" data-field="bedrijfId"><a href="#"><input type="radio" name="drp1" />Company 1</a></li>
<li data-value="38" data-field="bedrijfId"><a href="#"><input type="radio" name="drp1" />Company 2</a></li>
<li data-value="42" data-field="bedrijfId"><a href="#"><input type="radio" name="drp1" />Company 3</a></li>
How do I select one of the companies from the dropdown menu?
usually I do Win automations, so I have no skills at all to handle HTML forms :-/
The script to catch and syntax check the required information from Excel is done.
Now I'd like to automate the upload using this form, too:
What browser is easiest to do so? (IE, Chrome, FF) The Values $DeckCode, $DeckName, $DeckDefinition shall go to their HTML form fields finally "click" the button "upload flashcards" <table width="70%" class="cssCenter" border="0"> <tr> <td style="width: 1%">Deck Code</td> <td style="width: 100%"><input name="ctlDeckCode" type="text" id="ctlDeckCode" style="width:50%;" /> (no spaces allowed)</td> <td></td> </tr> <tr> <td style="width: 1%">Deck Name</td> <td style="width: 100%"><input name="ctlDeckName" type="text" id="ctlDeckName" style="width:50%;" /> (optional)</td> <td style="width: 1%" align="right"><input type="submit" name="ctlUpload" value="Upload Flashcards" id="ctlUpload" /></td> </tr> <tr> <td valign="top" style="padding-top: 5px" >Flashcard Text</td> <td colspan="2"><textarea name="ctlFlashcardText" rows="2" cols="20" id="ctlFlashcardText" style="height:280px;width:100%;"></textarea></td> </tr> </table> If someone kindly could jump in showing how to address just one of the input fields and how to "click" the "upload flashcards" button, I should be able to do the rest myself.