Search found 2 matches
- Sat Aug 14, 2021 7:09 am
- Forum: Technical / Scripting
- Topic: VBA/Excel regex with arrays or cells
- Replies: 1
- Views: 2548
VBA/Excel regex with arrays or cells
I'm trying to pattern match according to a given set of cells. For example, I'd like find the locations(row/column) of the headers of a spreadsheet, but the headers may slightly vary in name from worksheet to worksheet. I considered storing the range of cells in an array and using a regex from there...
- Fri Jul 02, 2021 5:05 pm
- Forum: General Discussion
- Topic: Schedule A Macro To Run With Scheduled Tasks
- Replies: 1
- Views: 10488
Schedule A Macro To Run With Scheduled Tasks
I have a worksheet that runs a query from an external data program. I have made a macro that refreshes the worksheet and this works ok. Is there a way I can get Scheduled tasks to automatically update this workbook eg overnight. I do not want to leave the workbook open either. Can task scheduler ope...