Steve1040 Posted July 29, 2018 Share Posted July 29, 2018 1. Log into Chase bank account I've setup a automated process that retrieves the balance from my cell phone. The SMS is sent to my Gmail account, The balance is then added to Google Sheets document using Zapier 2. Retrieve available balance and save to Excel document This is where I'm stuck - Can't get the balance from the Google Sheets doc to Excel. 3. Refresh formulas within Excel file 4. Gotp Billpay area in Chase account 5. Enter payment amounts from Excel file 6. Submit payments 7. Log out of Chase I'm wondering if Autoit can perform all 7 steps, without the need for a process like I've setup in step 1. Thanks for the guidance Steve Link to comment Share on other sites More sharing options...
FrancescoDiMuro Posted July 29, 2018 Share Posted July 29, 2018 Hi @Steve1040 If you could post your script, and talk us about the Google Sheet... Click here to see my signature: Spoiler ALWAYS GOOD TO READ: Forum Rules Forum Etiquette Link to comment Share on other sites More sharing options...
careca Posted July 29, 2018 Share Posted July 29, 2018 I believe it can do it all, but there has to be quite some effort to make it work. Spoiler Renamer - Rename files and folders, remove portions of text from the filename etc. GPO Tool - Export/Import Group policy settings. MirrorDir - Synchronize/Backup/Mirror Folders BeatsPlayer - Music player. Params Tool - Right click an exe to see it's parameters or execute them. String Trigger - Triggers pasting text or applications or internet links on specific strings. Inconspicuous - Hide files in plain sight, not fully encrypted. Regedit Control - Registry browsing history, quickly jump into any saved key. Time4Shutdown - Write the time for shutdown in minutes. Power Profiles Tool - Set a profile as active, delete, duplicate, export and import. Finished Task Shutdown - Shuts down pc when specified window/Wndl/process closes. NetworkSpeedShutdown - Shuts down pc if download speed goes under "X" Kb/s. IUIAutomation - Topic with framework and examples Au3Record.exe Link to comment Share on other sites More sharing options...
Earthshine Posted July 29, 2018 Share Posted July 29, 2018 (edited) <snip> Edited July 29, 2018 by Melba23 Unpleasantly aggressive comment removed FrancescoDiMuro and TheXman 1 1 My resources are limited. You must ask the right questions Link to comment Share on other sites More sharing options...
Juvigy Posted July 30, 2018 Share Posted July 30, 2018 Yes, it can be done in many ways. Instead of google sheets and so on , you can just get the balance via the IE functions and then write it in the excel file with the excel functions. Earthshine 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now