By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


GenerateAllExcelAndDecks - batch - run multiple SQL's and Creates multiple PPT decks

Steps
  • Turn off RemoteRequests (don't open excel in this window
  • Ask user to continue y/n bc long running task
  • Load array of what to run
  • for each item
    • Skip certain ones (if "email" in name)
    • Sets a range variable from the array
    • Logic to skip if the file already exists
    • Check the output file is set
    • Go to the sheet with the generation instructions
    • Generate the Excel files from SQL
    • Generate the PPTs

    • blog comments powered by Disqus