Search results

Hi Maybe not the most ideal answer, because essentially I couldn't be arsed reading through the code trying to figure out where it's going wrong, but I do have a tip that might prove useful. Instead of create the new excel object via that method, if you add the 'Microsoft Excel 12.0 Object...

Workbooks("budget.xlsx").Close True

Howdy I've been in a similar situation to yourself, luckily ODBC access is allowed at my work on the data warehouse. This is probably how i'd go about getting it automated with minimal engagements of other parties. I'd suggest trying to get an automated distribution of the table dumps...