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

expertatexcel.com

 


Home
What can Excel do?
Learning Excel Books
Basic concepts Immediate window Macros 101 Syntax Use existing code Hello world Math formulas Functions Modifying Recorded Macros
Selecting Moving data Formatting Clipboard Range names Filters Sorting Fill Combining Hyperlinks Comments Options Vlookup Conditional Formatting Data validation Pivot Tables Charts Charts
Debugging Strings Active This vba statements VBA functions Run stuff
Workbook Sheet Cells Rows Column Range Selection Methods Properties Events Collections Chart
Variables Data types variables/scope Conditionals Loops functions/sub Arrays testing Batch Software dev techniques Backup/Recovery Documentation Wrappers webservice Refactor
#Errors Problems Too Slow/Optimize Error handling Problem Solving Method Someone else's sheet complex formula
Date/times Code Generation Random Shortcuts Forms Special Chars Customize your training Work and learn
Reporting Sample projects Reconcliation Adjusting data Generate Slides Special Characters
Outlook Web Database Files PPT Word API Objects Script host Dos Bloomberg JIRA Input Spreadsheets or files
Stocks Bitcoin Sports Job Productivity Project Management Tracking Health Games Programmer

Generate_deck - udf - that runs commands in spreadsheet to generate ppt slides

Overview


Main command processor of the PPT generation. It contains the commands needed to generate the slides.

Important that it uses a Template concept and each slide is named which has a meaning.

Instruction Spreadsheet
  • Command
  • parameter to command


    Algorithm
  • Setup
    • Error handling
    • Recalc Full
    • Ignore remote requests
    • Log to file
    • Don't Ask setting because running unattended
  • Inputs
    • Get what to generate from range name that is a data validation
    • decide whether "quick" version
    • All decks or one deck?
    • Verify to the user they're ok
    • Get the Month-end
  • Process
    • Recalc if one is needed
    • Open the input ppt template
    • Expand hidden stuff via the outline
    • get the last row
    • Close the outline (hide rows
    • Go to the Generator sheet
    • For each row in the PPT instruction
      • update statusbar
      • Process commands in column 1
        • stop
        • end
        • comment
        • Delete - deletes a slide name in column 2
        • Deleteslides - deletes all slides containing text it col 2
        • fileout Filename - opens filename
        • close - closes the activeworkbook
        • save - Saves excel to the fileout name
        • copy - col 2 (sheet name) col 4 (from address) col 5 (to Address) with special logic if a chart (chart in col 4)
          • activate the chart based on its name
          • copy selected chart or data to clipboard
          • save the top, left, height, the width of the "to" chart
          • Activate the to chart on PPT in the template and delete it
          • Paste in the chart and set its name, top, left, height and width that was saved
          • if just data then paste it
        • file
          • close active excel don't save the changes
          • open the filename in col 2 read only
        • Sheet in col 4 ??
        • xl chart in col 5
        • check that it's a chart
        • CopyChartToPPT


    • Update TOC
    • Set PPT as normal file attribute so it can be updated as it was readonly
    • Update the PPT
    • handle case where in use by appending a random number to the end of it
    • Add other slides if the "Global deck"


    •