Catalogue Search | MBRL
Are you sure you want to remove the book from the shelf?
{{itemTitle}}
1,747
result(s) for
"Visual Basic"
Sort by:
Excel VBA Programming for Dummies
Find out what Excel is capable of with this step-by-step guide to VBA Short of changing the tires on your car, Microsoft Excel can do pretty much anything. And the possibilities are even more endless when you learn to program with Excel Visual Basic for Applications (VBA). Regardless of your familiarity with Excel VBA, Excel VBA Programming For Dummies can enhance your experience with the popular spreadsheet software. Pretty soon, you'll be doing things you didn't think were possible in Excel, from automating processes to writing your own worksheet functions. You'll learn how to: Understand the basic tools and operations of Visual Basic for Applications Create custom spreadsheet functions that make life easier for you and the people maintaining your spreadsheets Deal with errors and exceptions and eliminate the bugs in your code Perfect for anyone who's never even heard of Excel VBA, Excel VBA Programming For Dummies is also a fantastic resource for intermediate and advanced Excel users looking for a heads-up on the latest features and newest functionality of this simple yet powerful scripting language.
eBook
Modeling arithmetic systems of elliptic curve cryptography using Microsoft Excel VBA
Purpose. This study aims to develop a new teaching module to illustrate the arithmetic systems of Elliptic Curve Cryptography, a powerful yet simple algorithm for information security, by exploring the capability of the Visual Basic Applications of Microsoft Excel in user friendly way. Methodology. The research is performed using research and development approach, which is divided into five steps utilizing VBA features of Microsoft Excel. It starts with modeling arithmetic in Microsoft Excel spreadsheet, then testing the validity through calculation and setup of the actual arithmetic of Elliptic Curve Cryptography using VBA Excel, before performing the test of the VBA application and finally visualizes the results in graphical mode. Findings. Novel teaching software based on of Microsoft Excel Visual Basic Applications is produced that is able to simulate arithmetic system behind Elliptic Curve Cryptography in an easy way for students. Originality. To the best of the authors’ knowledge, this is the first simulation based on Excel VBA to illustrate the arithmetic systems of Elliptic Curve Cryptography for teaching purposes. Practical value. In general, mastering cryptography will need a steep learning curve; however, using Microsoft Excel as a simulation platform will accelerate learning. The main practical value is the ease of Microsoft Excel, which will turn cryptography learning which was commonly very difficult for student to become easier and user friendly.
Journal Article
Thermodynamic Prediction of Scale Formation in Oil Fields During Water Injection: Application of SPsim Program Through Utilizing Advanced Visual Basic Excel Tool
This study focuses on the design and validation of a computer program named “SPsim”, developed using Visual Basic coding and advanced Excel tools to predict the formation of sulfate mineral deposits during water injection in oil fields. Water injection for secondary oil recovery is an effective economic strategy, but it can be negatively impacted by the formation of sulfate minerals such as calcium sulfate, gypsum, barium sulfate, and strontium sulfate. The results of this study demonstrate that SPsim can accurately predict the formation of these mineral deposits based on the composition of the formation water and injection water under various temperature and pressure conditions. Specifically, the formation of barium sulfate and calcium sulfate is observed under certain conditions, which is a significant concern in oil fields. The study also highlights that calcium sulfate, barium sulfate, and strontium sulfate are among the most challenging mineral deposits in the studied fields, while the formation of gypsum deposits is less significant. The program was compared with results from other software tools, such as ScaleChem 3.2 and StimCad 2, as well as field observations. The findings indicate that SPsim provides a reliable and effective tool for predicting and managing sulfate scaling in water injection operations, making it a valuable resource for both industrial and academic applications.
Journal Article
Supply Chain Management of Outsourcing Module Components Decision-Making using Analytical Hierarchy Process and Visual Basic Application in Automotive Body-in-White Welding Assembly Line
Supply Chain Management (SCM) has gained the attention of business organizations as it affects corporate efficiency and competitive advantage. Component outsourcing is an important element of SCM practices and is considered to be a multi-criteria decision-making problem (MCDM) in vendor selection processes. However, decision-making on the selection of vendors is crucial, as the outsourcing program is influenced by multiple technical and commercial criteria of vendors. Developing an Excel-based Analytic Hierarchy Process (AHP) model for vendor selection therefore helps to simplify selection processes. In this paper, a Visual Basic Application (VBA) Excel-based AHP model was developed, which multiple criteria, sub-criteria and vendors and simultaneously compared with multiple main criteria, sub-criteria and alternatives for vendor selection. The model was validated with a case study of selecting a vendor for module components of body-in-white (BIW) in automotive industry as industrial application. As a result, vendor A is the best vendor since it has the highest overall score of 0.35206. Whereas vendor B is 0.239, vendor C is 0.126, vendor D is 0.146 and vendor E 0.135. In addition, the model is capable of resolving other MCDM problems. This paper provides resources such as AHP methodology, validating method and VBA code programming to readers in developing their own VBA Excel-based model.
Journal Article
Professional Visual Basic 2010 And . NET 4
Intermediate and advanced coverage of Visual Basic 2010 and .NET 4 for professional developers If you've already covered the basics and want to dive deep into VB and .NET topics that professional programmers use most, this is your book. You'll find a quick review of introductory topics-always helpful-before the author team of experts moves you quickly into such topics as data access with ADO.NET, Language Integrated Query (LINQ), security, ASP.NET web programming with Visual Basic, Windows workflow, threading, and more. You'll explore all the new features of Visual Basic 2010 as well as all the essential functions that you need, including .NET features such as LINQ to SQL, LINQ to XML, WCF, and more. Plus, you'll examine exception handling and debugging, Visual Studio features, and ASP.NET web programming. Expert author team helps you master the tools and techniques you need most for professional programming Reviews why Visual Basic 2010 will be synonymous with writing code in Visual Studio 2010 Focuses on .NET features such as LINQ, LINQ to SQL, LINQ to XML, WPF, workflow, and more Discusses exception handling and debugging, data access with ADO.NET, Visual Studio features for Visual Basic developers, Windows programming with Windows Forms, ASP.NET web programming with VB, communication interfaces, Windows workflow, and threading This Wrox guide presents you with updated coverage on topics you need to know now.
eBook