Site Tools


services:scripting

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

services:scripting [2025/01/25] – created adminservices:scripting [2025/01/26] (current) admin
Line 3: Line 3:
 ===== About ===== ===== About =====
  
-Scripting allows you to automate frequent computer tasks like backing up folders and +Scripting allows you to automate frequent computer tasks like backing up folders and processing data.
  
 ==== VBA ==== ==== VBA ====
  
-VBA is great for automating tasks in Microsoft office. It integrates tightly with the applications allowing for detailed control. Most of my experience is manipulating data in Excel. VBA allows extending Excel forms to be very powerful.+VBA is great for automating tasks in Microsoft office. It integrates tightly with the applications allowing for detailed control. Most of my experience is manipulating data in Excel. VBA allows extending Excel to be very powerful by adding custom buttons and functions. Most frequent tasks in excel can be reduced to a single click.
  
 ==== Python ==== ==== Python ====
  
-Python is great for manipulating data and creating reports. It has a lot of powerful libraries for processing data. This is a great step up from VBA if you need something more powerful. +Python is great for manipulating data and creating reports. It has a lot of powerful libraries for processing data. This is a great step up from VBA if you need something more powerful. Most of my experience is with a library called [[https://matplotlib.org/stable/plot_types/index.html|Mathplotlib]] that allows for detailed and visually pleasing representation of data
  
 ==== AHK ==== ==== AHK ====
services/scripting.1737844382.txt.gz · Last modified: 2025/01/25 by admin