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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 509 - 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


    •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit