• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Script Refreshing Excel Data and Saving to .CSV

goobernoodles

goobernoodles

Golden Member
Well this is a long shot, but does anyone know how to script the refreshing of an excel query then saving AS to .csv (and overwrite the previous file)?

There's an option within Data -> Connections -> Usage tab for refreshing data on a schedule. Not sure if that refreshes when the file isn't open or not. Doubt it.
 
you could do this in vba. the spreadsheet can refresh every time the workbook is opened then saves and overwrites the previous file.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top