Programming PowerPoint With VBA Straight to the Point

by Eduardo N Sanchez

Overview

This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming. It also includes a chapter for interfacing between PowerPoint and Word, Excel, Access or Outlook.

Product Details

ISBN-13:	9781615471638
Publisher:	Holy Macro! Books
Publication date:	02/28/2022
Series:	Straight to the Point
Sold by:	INDEPENDENT PUB GROUP - EPUB - EBKS
Format:	eBook
Pages:	57
File size:	5 MB

About the Author

Eduardo N. Sanchez is a Brazilian Chemical Engineer with a long-time penchant for computers. Since college he has been programming using languages such as Fortran, Basic, Algol, Pascal, C and most recently VBA. Eduardo enjoys answering Excel and Office questions at Internet forums, as this is a great way to get in touch with topics that could otherwise remain unnoticed. When he is not tackling a computational challenge with electronic music in the background, Eduardo likes to watch Star Trek episodes and play with the family's Dachshund. Eduardo N. Sanchez is a Brazilian Chemical Engineer with a long-time penchant for computers. Since college he has been programming using languages such as Fortran, Basic, Algol, Pascal, C and most recently VBA. Eduardo enjoys answering Excel and Office questions at Internet forums, as this is a great way to get in touch with topics that could otherwise remain unnoticed. When he is not tackling a computational challenge with electronic music in the background, Eduardo likes to watch Star Trek episodes and play with the family's Dachshund.

Table of Contents

Getting Started What is HTML? Performing Queries A static query A dynamic web query Querying with VBA Interacting with Sites without using a Browser What is JSON? Getting data from the Web programmatically Getting data from Web page elements Posting data over the Internet Authenticated requests Internet Explorer and VBA Transferring a Web table to the worksheet Working with events Introducing Selenium Installing Selenium Internet Explorer and Selenium Google Chrome and VBA Running JavaScript on a page Using XPath to find elements Microsoft Edge and VBA Finding elements by CSS selectors Downloading a file Creating a PDF file from scratch Wrapping up Selenium Power Query and the Web Connecting to a Web table – the direct way Connecting to a Web table – the long way Conclusion