Visual Basic for Applications (VBA)

Visual Basic for Applications is a programming language developed for Microsoft applications such as Word, Excel, and PowerPoint. VBA is similar to Visual Basic, but only operates within an existing application rather than stand-alone execution.

In the engineering world, VBA is a useful language for developing automated spreadsheets or even macros for supported CAD programs such as Catia V5. Repetitive tasks can be written in VBA and reduced to a single button click. VBA macros can be executed from a Python script, which allows for complex automation programs to take advantage of VBA's comfortable interface with the Microsoft Office Suite.

The following links demonstrate my ability to use VBA to give an engineering department a competitive edge.

Comments

Post a Comment

Popular posts from this blog

Automated ECN Submission - Pseudocode

 Automate redline function(BU_####### string) //Retrieve Redlines open http://elstr.stadlerrail.ch/change#number=BU_####### Navigate page and select attachment.pdf Download attachment.pdf to /workfolder //Fill out Change Management Form using url class <change details> store class."alpha main-title" as string Title store class."cd-assignment" as string Zuordnung store class."cd-type" as string Typ store "Technik" as string Abteilung Open Antrag.docx from /systemfolder Write variables as text Save Antrag.docx as Antrag.pdf in /workfolder //Update Antrag Open AE_Antraege_CalTrain.xlsm Row_count(sheet) as lngRow Select Cell(lngRow+1,1) Fill(Title,Zuordnung,Typ,Abteilung) store lngRow+1 as int lfdno //Combine into single PDF EITHER Open Adobe X Pro function combine pdf For each *.pdf in /workfolder select .pdf ok combine OR Open Antrag.docx insert pagebreak insert object -> attachment.pdf Save product as ...
Read more

Bear Lake Observatory

Image
Objective The purpose of this project was to design and implement an improved system to open and close the USU Bear Lake Observatory (BLO) dome and provide alerts to the user on the status of the dome as well as the weather conditions at the dome. The previous system that was used was functional, but did not have exceptional functionality. The following problems arose during use of the previous observatory dome system: The previous system ran through a mac mini that was connected to a PLC. This means that when the Wi-Fi was down, the dome was inaccessible unless the dome user partially disassembled the dome.  Previously, the dome did not contain any sensors to detect rain or other weather conditions that could damage the telescope. The only way of knowing if it was raining at the dome was by checking the weather conditions and looking at the cameras at the dome. When the bump guard was triggered, power was cut from the dome and could only be reestablished when the bump guard was re...
Read more

Engineering Capacity Planning

Image
1       Introduction Stadler relies primarily on experience and intuition when making capacity decisions. Although this strategy has proved historically successful for the company, there isn’t a concise feedback loop to validate and improve the predictions. It is difficult to communicate expectations across the project phases with regard to predetermined budgets. Managers with limited understanding of the overall workflow are at risk of understaffing their departments at critical phases. This in turn leads to missed payment milestones, and management is pressured to add emergency personnel to make up for lost time. Although coined for a separate industry, Brooks’ Law takes shape, and that is “adding manpower to a late software project makes it later”. Brooks’ Law describes a scenario where total productivity declines due to resources being diverted to onboard potential contributors. Broadly speaking, strained capacity increases the total cost by means of d...
Read more