Aplikacje biurowe

VBA na sto dwa, czyli 102 ćwiczenia z wykorzystaniem VBA

Piotr Janus

Co Ty wiesz o VBA? Co wiesz i co potrafisz ― to dwie różne sprawy. Od wiedzy do umiejętności prowadzi droga usłana... praktyką. A praktykę najlepiej i najbezpieczniej zdobywa się nie w zawodowym boju, gdy na ręce patrzą szef, koledzy z teamu i klient na dodatek, tylko w zaciszu własnego pokoju, przy ulubionym biurku, na ulubionym krześle, w czasie wolnym. Ćwicząc i bawiąc się po prostu! I właśnie w tym celu powstała ta książka. Autor zawarł w niej 102 ćwiczenia, dzięki którym przejdziesz od teorii do praktyki Visual Basic for Applications i będziesz gotów do swobodnego tworzenia własnych programów. Rozwiązanie zaproponowanych ćwiczeń wymaga stosowania pętli For-Next, For Each-Next, Do-Until, Do-While, struktur If-Then-Else, Select Case, funkcji Excel i VBA, odwołania do metod lub właściwości obiektów itd. Wielokrotne wykonywanie podobnych czynności gwarantuje, że polecenia zapadną Ci w pamięć. Książka pomoże Ci wykształcić programistyczny sposób myślenia, niezbędny do tworzenia własnych rozwiązań. Każdy rozdział składa się z jednego lub kilku ćwiczeń, które polegają na napisaniu procedur Sub lub Function. Do wszystkich poleceń dołączono przykładowe rozwiązania. Na początek możesz z nich skorzystać, potem jednak szukaj własnych rozwiązań. Do dzieła: Stwórz tabliczkę mnożenia Sprawdź, kiedy wypadnie najbliższy piątek trzynastego Policz dni wolne od pracy w kolejnym roku Napisz własny przelicznik walut Dowiedz się, czy trzymasz prawidłową masę ciała... ...a to dopiero początek zabawy!

Visualforce Development Cookbook. For developers who already know the basics of Visualforce, this book enables you to advance to the next level. With over 75 real-world examples accompanied by stacks of illustrations, it clarifies even the most complex concepts

Keir Bowden

Visualforce, in conjunction with Apex, makes it easy to develop sophisticated, custom UIs for Force.com desktop and mobile apps without having to write thousands of lines of code and markup. The Dynamic Binding feature of Visualforce lets you develop generic Visualforce pages to display information related to the records without necessarily knowing which data fields to show. This is accomplished through a formula-like syntax, which makes it simple to manage even a complex hierarchy of records.Visualforce Development Cookbook provides solutions for a variety of challenges faced by Salesforce developers and demonstrates how easy it is to build rich, interactive pages using Visualforce. Whether you are looking to make a minor addition to the standard page functionality or override it completely, this book will provide you with the required help throughout.Visualforce Development Cookbook starts with explaining the simple utilities and builds up to advanced techniques for data visualization and reuse of functionality. This book contains recipes that cover various topics like creating multiple records from a single page, visualizing data as charts, using JavaScript to enhance client-side functionality, building a public website and making data available to a mobile device.Visualforce Development Cookbook provides lots of practical examples to enhance and extend the Salesforce user interface.

VMware Cross-Cloud Architecture. Automate and orchestrate your Software-Defined Data Center on AWS

Ajit Pratap Kundan

Over the past two decades, VMware vSphere has been known as the most trusted andreliable virtualization platform. VMware Cross-Cloud Architecture shows you how to design and configure Cross Cloud Architecture by using VMware Cloud Foundation and vRealize Suite with various use cases across private, public, and hybrid Cloud. This book takes you through everything from a basic understanding of virtualization to advanced aspects of storage and network virtualization, clustering, automation, and management.This book will be your guide to designing all aspects of Cloud.We start with the challenges faced by a traditional data center, define problem statements for you, and then brief you on respective solutions. Moving on, all kinds of virtualization and Cloud offerings from AWS and IBM Soft Layer are introduced and discussed in detail. Then, you'll learn how to design IT infrastructures for new and existing applications with a combination of Cloud Foundation, vRealize Suite, and vSphere enabled with VSAN and NSX. Furthermore, you'll learn how to design and configure high availability, disaster recovery, and apply an appropriate compliance matrix.Toward the end of the book, you will learn how to calculate the TCO/ROI, along withthe VMware products packaging and licensing in detail.

VMware vCloud Director Cookbook. Over 80 recipes to help you master VMware vCloud Director

Daniel Langenhan

VMware vCloud Director is an enterprise software solution that enables the building of secure, private clouds by pooling together infrastructure resources into virtual data centers. The tool enables self-service via a web interface to reduce the management overhead and offers amazing possibilities for production and development environments. Thus, the tool will ensure efficient management of resources with data center efficiency and business agility.VMWare VCloud Director Cookbook will cover a lot of ground, ranging from easy to complex recipes. It will not only dive into networks, data-stores, and vApps, but also cover vCloud design improvements, troubleshooting, and the vCloud API.VMWare VCloud Director Cookbook is split into different sections, each of which deals with a special topic in vCloud - from networks, to vApps, to storage and design. This book contains over 80 recipes with the difficulty levels ranging from simple to very advanced. You will learn how to automate vCloud easily and quickly with the API, and also learn how to isolate a vApp and still fully access it without risking the network. Design considerations that need to be addressed while deploying the vCloud and more will also be looked into.VMWare VCloud Director Cookbook will make your life as an admin a lot easier by providing you with some good recipes that have been proven to work in small to large enterprises.

VMware vRealize Configuration Manager Cookbook. Click here to enter text

Abhijeet Shriram Janwalkar

VMware vRealize Configuration Manager (VCM) helps you to automate IT operations, manage performance, and gain visibility across physical and virtual infrastructure. It is continuously being used by enterprises to audit the configurations of the VMware infrastructure as well as the Windows, Linux, and UNIX operating systems.This book is filled with practical recipes through which you will learn about the latest features of vRealize Configuration Manager 5.8.X, starting with installation of various tiers of VCM followed by configuration management across physical and virtual servers.Throughout this book, you will explore how VCM can perform tasks such as patch management, compliance assessment, and software package distribution along with Machine filters for new platforms such as RHEL 7 and Windows 10. This book will ease your troubles while upgrading from the existing VCM to the latest version by providing you with step-by-step instructions about the process of migration along with upgrade and maintenance support. This book will help you understand how to integrate vRealize Configuration with other applications along with schedule management and also guide you on how to handle security issues.After reading this book, you will have a clear understanding of how VCM fits in the overall picture of the data center design from a patching and compliance perspective.

VMware vRealize Orchestrator Cookbook. Click here to enter text. - Second Edition

Daniel Langenhan

VMware vRealize Orchestrator is a powerful automation tool designed for system administrators and IT operations staff who are planning to streamline their tasks and are waiting to integrate the functions with third-party operations software. This book is an update to VMware vRealize Orchestrator Cookbook and is blend of numerous recipes on vRealize Orchestrator 7. This book starts with installing and configuring vRealize Orchestrator. We will demonstrate how to upgrade from previous versions to vRealize Orchestrator 7. You will be taught all about orchestrator plugins and how to use and develop various plugins that have been enhanced in Orchestrator 7. Throughout this book, you will explore the new features of Orchestrator 7, such as the introduction of the control center, along with its uses. You will also come to understand visual programming, how to integrate base plugins into workflows, and how to automate VMware. You will also get to know how to troubleshoot vRealize Orchestrator.By the end of this book, you will be able to get the most out of your Orchestrator installation, and will be able to develop complex workflows and create your own highly integrated automations of vRealize environments.

VMware vSphere 6.5 Cookbook. Over 140 task-oriented recipes to install, configure, manage, and orchestrate various VMware vSphere 6.5 components - Third Edition

Abhilash G B, Cedric Rajendran

VMware vSphere is a complete and robust virtualization product suite that helps transform data centers into simplified on-premises cloud infrastructures, providing for the automation and orchestration of workload deployment and life cycle management of the infrastructure. This book focuses on the latest release of VMware vSphere and follows a recipe-based approach, giving you hands-on instructions required to deploy and manage a vSphere environment.The book starts with the procedures involved in upgrading your existing vSphere infrastructure to vSphere 6.5, followed by deploying a new vSphere 6.5 environment. Then the book delves further into the procedures involved in managing storage and network access to the ESXi hosts and the virtual machines running on them. Moving on, the book covers high availability and fair distribution/utilization of clustered compute and storage resources. Finally, the book covers patching and upgrading the vSphere infrastructure using VUM, certificate management using VMCA, and finishes with a chapter covering the tools that can be used to monitor the performance of a vSphere infrastructure.

VMware vSphere 6.7 Data Center Design Cookbook. Over 100 practical recipes to help you design a powerful virtual infrastructure based on vSphere 6.7 - Third Edition

Mike Brown, Hersey Cartwright

VMware is the industry leader in data center virtualization. The vSphere 6.x suite of products provides a robust and resilient platform to virtualize server and application workloads.This book uses proven infrastructure design principles and applies them to VMware vSphere 6.7 virtual data center design through short and focused recipes on each design aspect. The second edition of this book focused on vSphere 6.0. vSphere features released since then necessitate an updated design guide, which includes recipes for upgrading to 6.7, vCenter HA; operational improvements; cutting-edge, high-performance storage access such as RDMA and Pmem; security features such as encrypted vMotion and VM-level encryption; Proactive HA; HA Orchestrated Restart; Predictive DRS; and more.By the end of the book, you will be able to achieve enhanced compute, storage, network, and management capabilities for your virtual data center.