_slidefab-2-how-to-create-one-output-file-per-loop-candidate-when-automating-powerpoint-slides.jpg "SlideFab 2: How to create one output file per loop candidate when automating Powerpoint slides from vba code in excel Video Screenshot Preview")
GalleryPlay Video:
(Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
⏲ Duration: 1 min 4 sec
✓ Published: 07-Mar-2018
✓ Published: 07-Mar-2018
Description:
Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video shows how SlideFab can decompose the output presentation into separate files, 1 presentation file per loop.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to empower Excel users. Typically coding skills in VBA (Visual Basic) are required to create PowerPoint presentations automatically. This is not the case with SlideFab 2. With decent Excel ski
Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video shows how SlideFab can decompose the output presentation into separate files, 1 presentation file per loop.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to empower Excel users. Typically coding skills in VBA (Visual Basic) are required to create PowerPoint presentations automatically. This is not the case with SlideFab 2. With decent Excel ski
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_excel-video-439-custom-functions-part-1.webp "Excel Video 439 puts several of the things we’ve learned over the past Excel Videos together to build a custom function in VBA.The custom function is a response to a question a while back in MGMA’s Excel Users group asking for a way to compare the fill color of cells.nnNotice a few things that are different about custom functions.Instead of starting the code like a subroutine with Sub and End Sub, we change to Function and End Function.Our function takes two parameters, the two cells w")
_intgrer-un-budget-avec-power-query.webp "Power Query est un add-in Excel positionné par beaucoup comme un outil d'ETL libre-service.nnQu'entend on par ETL et par libre-service ?nnJe vais plutôt prendre un exemple que vous rencontrez certainement régulièrement et qui vous fera comprendre la notion d'ETL.nnMa société a acquis récemment une autre entreprise et nous avons dorénavant 2 sites ou nous construisons les mêmes produits, au moins partiellement et de plus nous avons aussi des clients communs.nnChaque société a son propr")
_excel-video-420-vba-editing-shortcuts-and-selecting-the-current-region.webp "There are three very useful shortcuts in Excel Video 420.I’ll show you how to quickly comment and uncomment lines of code.For those of you who don’t write a lot of code, by comment I mean to have VBA skip over the line without running the code.You can use comments to document your code as well as to skip over lines of code you’ve decided not to run, but want to keep for reference in case you need them again.nnWe’ll also add a shortcut to the toolbar that indents or outdents (the op")
_slidefab-2-writing-an-excel-formula-as-loop-condition-when-automatically-creating-powerpoint-slides.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video explains how a loop condition can be used to leave out loop candidates based on a calculated condition. In this example the modulo operator is used as condition to only create every second slide.nnSlideFab 2 is a software to automatically produce PowerPoint slides from any Excel model. The idea is to empower Excel users. Typically coding skills in VBA (Visual Basic) are required to create PowerPoint")
SlideFab 2. Writing an Excel formula as Loop Condition when automatically creating Powerpoint slides
⏲ 1 min 5 sec ✓ 07-Mar-2018
![– Learn to use macros in Microsoft Excel [one hour]nnLearn more about:n• How to record macros : about the macro Editor : how to play your recordings : using the current selection : how to adjust recorded code. Cut the learning curve now.nnGet on iBooks Store:nhttps://itunes.apple.com/us/book/excel-2016-vba-record/id1084983012?ls=1&mt=13nnRecorded in Microsoft Excel 2016. nTested and optimized on iPhone 5 | iPhone 6 | iPhone 6 Plus | niPad | iPad Pro | MacBook Pro | iMac 5K.nnOn www.idesy](https://cdn7.hifimov.co/picture/preview/nUE0pUZ6Yl9cYaMcoJIiL_EhYzAioF9_nJEyol8_ZGD0BQRjAGxgMGN1LwHmL_D_Lmx1LzZmLGMvATZkAQEzMQNlMGAvATHkAJH1LwZ1LGL3BGR5MwpmAQxmLmuzMTWxLmqvZGt_LF1xKmVjZUtkAGNcXltbFTyTnH1iqv5wolysAwR0AQtkZQH5YJHjAJV1Z_AxAzZ5AJWwZ_R_LwEwZGD0MzDjZzHmLwEyZGIyAJVmAJR_AmxkBJL3ZmD5Z_Z-MzEvMTZ3LwR-AzRgMP0lZQO-ZGHj/(HiFiMov.co)_excel-2016-vba-record-ebook-trailer.webp "– Learn to use macros in Microsoft Excel [one hour]nnLearn more about:n• How to record macros : about the macro Editor : how to play your recordings : using the current selection : how to adjust recorded code. Cut the learning curve now.nnGet on iBooks Store:nhttps://itunes.apple.com/us/book/excel-2016-vba-record/id1084983012?ls=1&mt=13nnRecorded in Microsoft Excel 2016. nTested and optimized on iPhone 5 | iPhone 6 | iPhone 6 Plus | niPad | iPad Pro | MacBook Pro | iMac 5K.nnOn www.idesy")
_excel-video-423-introducing-loops.webp "We’ll start discussing loops in Excel Video 423.Loops are an important concept in programming, and there are several different ways to create a loop in VBA.We’ll start with a basic For…Next loop that runs code a set number of times.To keep things simple, we’ll use one variable that I’ll call A, and we’ll use it several times throughout the macro.Watch how the macro runs until A hits the limit of 8 that we define in our loop.nnWe’ll make the macro a little more complicated i")
_excel-video-417-identifying-ranges.webp "Excel Video 417 starts our discussion on identifying ranges for our VBA code to work on.In the Macro Recorder videos we were very concerned about which cell we started recording in.Once we can identify ranges of cells, it’s not as important which cell we’re in when we run the code.We’ll discuss several different ways to identify a range of cells, one or more cells in our spreadsheet we want to examine or change.We’ll use something called the ColorIndex property to change the back")
_excel-video-422-looping-to-dynamically-define-a-range.webp "There’s a way to programmatically define a range of cells to work with in Excel Video 422.I’m introducing loops, a way to repeat code a set number of times, in Excel Video 422.I’m also adding a few new functions as well, so I hope this isn’t too much for one video.Hopefully the idea of being able to use code to dynamically define a range makes sense and will be helpful for you in your macros and VBA.nnWatch for the code that tells Excel how many rows to work with in our example.T")
_excel-video-439-custom-functions-part-1.jpg)
_intgrer-un-budget-avec-power-query.jpg)
_excel-video-420-vba-editing-shortcuts-and-selecting-the-current-region.jpg)
_slidefab-2-writing-an-excel-formula-as-loop-condition-when-automatically-creating-powerpoint-slides.jpg)
_excel-2016-vba-record-ebook-trailer.jpg)
_excel-video-423-introducing-loops.jpg)
_excel-video-417-identifying-ranges.jpg)
_excel-video-422-looping-to-dynamically-define-a-range.jpg)
![[+]](/images/menu.gif){kind=small}