First post, so please be gentle
I’m having a bash at creating a PoC for our business, and I want to automate the refresh of several spreadsheets that are connected to a variety of data sources (ODBC and SQL mostly) and are currently manually refreshed several times per day.
I can’t seem to get this working reliably via the Desktop Recording method (once I’ve called the workbook to open, the process can’t find the Excel window that was selected as part of the recording process), and I can’t seem to find any functionality to refresh all data sources in the Excel package (or any others, for that matter).
Anyone got any ideas, please? Bear in mind that I’m very much a novice, and am working my way through the first modules of the Academy as we speak!
Many thanks in advance