Hi
I have a windows program to download stock prices. There is no command line version of it. Is it possible to use Powershell to do the following:
start program
press download button or alt button plus d
wait (for program to download prices) this can take about 5 minutes or so
press close button
exit program
If yes, how would I do it?
Thank you
Hi @RichMatheisen-8856. Can you please help me with this? I got this far:
Start-Process -FilePath "program path"
$ProcId = (Get-Process program_name).id
Sleep -Seconds 60 # give the program 1 minute to open
$wshell = new-object -com wscript.shell
$wshell.AppActivate("program_name")
$wshell.Sendkeys("%d")
Sleep -Seconds 600 # give the program 10 minutes to finish the download
# select Convert button
#$wshell.Sendkeys("%c")
#Sleep -Seconds 600 # give the program 10 minutes to convert the data to CSV
Stop-Process $ProcId
There is a button called "Convert" that doesn't appear to be accessible via keyboard shortcuts. I have to use my mouse to select it. Is there a way to select that button by searching for the text "Convert". Once found then press enter? Thank you
Using the "tab" key to navigate to that button doesn't work? Arrow keys? Is there a default key, like "enter" that would activate that key?
If it's a web page you can probably see exactly what's on the page, either with a program like Fiddler or by "screen scraping" (there are a good number of results in a web search for "powershell screen scrape").
If it's an executable I think you'd have to get contents of the window. It used to be pretty easy to do with character-based applications. I expect it's a lot harder to do with graphics.
I suspect the application goes to a Web service/URL to get prices?
How about you explore invoke-webRequest cmdlet and export downloaded prices to a file
17 people are following this question.
