_excel-video-406-vba-code-created-by-the-macro-recorder.jpg "Excel Video 406 VBA Code Created by the Macro Recorder 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: 2 min 65 sec
✓ Published: 21-Mar-2015
✓ Published: 21-Mar-2015
Description:
Excel Video 406 is a brief introduction to the Visual Basics for Applications code created by the Macro Recorder.Alt+F11 is the keyboard shortcut to get to the VBA screen.We’ll see where Excel stores the code generated by the Macro Recorder and get a 30,000 foot perspective on what the VBA code is doing.Don’t worry if the code looks complex to start with.We’ll cover what the VBA code is doing in future Excel Videos.The point for today is that if we’re careful with absolute and
Excel Video 406 is a brief introduction to the Visual Basics for Applications code created by the Macro Recorder.Alt+F11 is the keyboard shortcut to get to the VBA screen.We’ll see where Excel stores the code generated by the Macro Recorder and get a 30,000 foot perspective on what the VBA code is doing.Don’t worry if the code looks complex to start with.We’ll cover what the VBA code is doing in future Excel Videos.The point for today is that if we’re careful with absolute and
Share with your friends:
Whatsapp | Viber | Telegram | Line | SMS
Email | Twitter | Reddit | Tumblr | Pinterest
Related Videos
_redteam-asr-bypass-and-amsi-bypass-for-excel-macro-dll-dropper.webp "This video shows how to embed a dll in an Excel document with MacroPack Pro. In this case the payload is ReactOS")
_automatically-creating-slides-with-powerpoint-charts-based-on-an-excel-workbook-with-slidefab-2.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video demonstrates how to automatically create slides in Powerpoint using SlideFab. Each slide will contain a Powerpoint chart which and SlideFab will update the data range for each of these charts automatically. The first part of the video shows how to create an empty Powerpoint slide with an empty Powerpoint chart on it as template. In the second part the video explains how an Excel model can be built wh")
⏲ 2 min 12 sec ✓ 16-Mar-2018
_redteam-excel-4-0-xlm-shellcode-using-macropack-pro.webp "This video shows how to trojan an Excel sheet with a malicious XLM macro injecting a meterpreter shellcode. nThis video was uploaded in the context of a blog post concerning addition of XLM payloads to MacroPack Pro (https://blog.sevagas.com/?EXCEL-4-0-XLM-macro-in-MacroPack-Pro)nnIn the video I first open the file, then I open it again after it is trojaned with XLM macro.nnHere is the command line used to generate the payload: necho meterx86_no0.bin | macro_pack.exe -t SHELLCODE -o --xlm --stea")
_excel-video-405-more-tricks-to-help-the-macro-recorder.webp "Watch three tricks to help the Macro Recorder do a better job in Excel Video 405.The first trick is to switch between the absolute and relative references we discussed in Excel Video 404.Watch how I start with an absolute reference to cell A1 so that no matter where I am in the spreadsheet, my macro starts at cell A1.Once we’re there, I switch to relative references so that the second trick will work.nnTrick number two is to use arrow keys in combination with keys like End, Shift and Ctr")
_slidefab-2-how-to-create-a-basic-92.webp "Go ahead and try it yourself: Free trial available at https://slidefab.com/freetrialnnThis video demonstrates how to set up a simple Hello World workbook and presentation with SlideFab 2. It contains the most simple case where a formula-based text from Excel is multiple times written to a shape in a Powerpoint presentation.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) a")
_automatically-creating-powerpoint-presentation-category-trees-from-excel-with-slidefab-2.webp "This SlideFab 2 video shows how to create category trees automatically. It features various advanced SlideFab 2 features such as slide loops, sort order and VBA code calls. This example visualizes category spend and puts each category on one or more tree slides where the branches resemble sub category spend. For each sub category the top 3 suppliers and top 3 countries by spend are shown. The Powerpoint to Excel automation then creates the slides automatically within minutes. This helps to speed")
⏲ 1 min 80 sec ✓ 24-Jul-2018
_microsoft-excel-2010-declaring-variables-and-adding-remarks-to-vba-code.webp "Custom Guide evaluates and improves the essential software skills of your staff for success in today's work place with interactive assessments that evaluate knowledge and deficiencies.")
_fractal-energy-storage-model-v-21-12-updates.webp "View the latest updates and new features of version 21.12 Fractal Model (released December 2021). The Fractal Model™ is a powerful technoeconomic energy storage and hybrid system modeling tool that provides investment grade analysis while simulating performance, degradation, warranty, costs and revenue to optimize the economics of your project. This tool is an excel package interface with an additional JavaScript calculation engine through a Microsoft 365 Add-In. nnThe tool is intended for pro")
_redteam-asr-bypass-and-amsi-bypass-for-excel-macro-dll-dropper.jpg)
_automatically-creating-slides-with-powerpoint-charts-based-on-an-excel-workbook-with-slidefab-2.jpg)
_redteam-excel-4-0-xlm-shellcode-using-macropack-pro.jpg)
_excel-video-405-more-tricks-to-help-the-macro-recorder.jpg)
_slidefab-2-how-to-create-a-basic-92.jpg)
_automatically-creating-powerpoint-presentation-category-trees-from-excel-with-slidefab-2.jpg)
_microsoft-excel-2010-declaring-variables-and-adding-remarks-to-vba-code.jpg)
_fractal-energy-storage-model-v-21-12-updates.jpg)
![[+]](/images/menu.gif){kind=small}