Automate tasks using VBA as a Chemical Engineer

Enable the developer's ribbon in excel, then record a macro in the visual basic editor to automate a table task, while noting relative references and generated code.

Explore VBA data types, including strings, doubles, integers, arrays, and objects, and learn to use var type to determine variable types and handle cells, ranges, and workbooks.

Manipulate VBA data types by adding, subtracting, and concatenating numbers and strings, convert between decimal and double types, and inspect results in the immediate window.

Explore manipulating strings in VBA using len, left, right, and mid to extract substrings, check for characters, and replace text.

Explore conditionals in VBA, using if statements and the select case (switch) to validate input and output based on variable values, with practical examples for strings, numbers, and empty cells.

Leverage Excel's input box to collect user input with prompt and title, validate with an if statement, note that output remains string by default, and convert to double for numbers.

Automate tasks by using for and for each loops to iterate through cell ranges, assign values, and build dynamic ranges with concatenation in VBA.

Explore how chemical engineers can combine conditionals with for loops in VBA to control output, using if statements and string checks to tailor results.

Explore how sub procedures and functions differ in VBA, with subs not returning values and functions returning a value. Learn to reuse code via functions with parameters and manage scope.

Explore how Excel objects model workbooks and worksheets, exposing properties, methods, and events like open, save, and activate to automate tasks in VBA.

Explore how to work with Excel workbook objects in VBA, using the active workbook, the locals window, and the workbooks collection, and save new workbooks with save as.

Learn to automate worksheet creation with VBA: group tables, create new sheets for each stream, name them, attach the macro to a button, and check sheet existence.

Automate data entry for chemical engineering tables in VBA by looping through streams, copying tables to new sheets, adding comments, and handling dynamic ranges and errors.

Create a VBA function to calculate pipe size from flow rate, density, and viscosity in Excel. Apply the pipe sizing procedure to determine the minimum diameter and nominal diameter.

Develop a VBA function to compute the preliminary pipe diameter from a volumetric flow rate and a maximum velocity criterion, using schedule, roughness, and optional parameters with xlookup and match.

Calculate the final pipe diameter from pressure drop criteria using a VBA macro in Excel. Iterate nominal diameter with loops guided by velocity and Reynolds number to meet delta P.

Automate pump calculations with a macro that computes discharge pressure drop and net positive suction head from suction and discharge piping segments, integrating data from two tables and sizing sheets.

Define variables based on user input to route VBA actions by button name, select sheets such as pump suction and pump discharge, and determine single or two phase sheet types.

Verify sheet existence with evaluate and isref, then duplicate a single phase or two phase calculation sheet for pipe sizing, name and unhide it, and run the macro.

Use a VBA macro to link the original pump sizing sheet with added pipe sizing sheets, copying suction and discharge data and computing pressure drops for single-phase and two-phase fluids.

Automate data transfer from pump calculations to the data sheet with a VBA macro, streamlining copying of suction head, flow rate, density, and other parameters across pumps.

Create and assign macros in Excel to open a source file and a target data sheet, then copy values between pump calculations and data sheets using file dialogs.

Learn to add data more elegantly in VBA by using arrays and for each loops to map source to target cells, increase i, and copy values efficiently.

Learn to extend a VBA macro that copies data between templates by letting users update source and target references via a prepared data table and sheet-driven workflow.

Open a multi-select file dialog to load multiple pump calculation files, store them as an array of paths, and automatically create or reuse a data sheets directory.

Learn to automate datasheet management with VBA by accessing the file system, looping through P1 and P2 files, copying data, and creating or updating datasheets from a template.

Export the calculation file to pdf, saving target files in pdf format by specifying the file name, extension, and the correct type format.