In my previous post, I showed you how to create a clickable button in Excel. That button displayed a simple message box. Now, I want to show you how to use the button to kick off a PowerShell script.

We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell. In a recent series of posts, I explained how to launch a PowerShell script ...

Anthropic on Tuesday announced a new Claude feature that some users should appreciate. The chatbot can now create files for you based on the instructions you provide in a prompt. Claude can generate ...

ExcelTable is a pipelined table interface to read Excel files (.xlsx, .xlsm, .xlsb, .xls, .xml), ODF spreadsheet files (.ods), and flat files (delimited or positional) as if they were external tables.

Community driven content discussing all aspects of software development from DevOps to design patterns. When you create an Amazon EC2 instance, AWS generates the ...

Microsoft has announced that it will start disabling external workbook links to blocked file types by default between October 2025 and July 2026. After the rollout ...

Sometimes you need to quickly convert an image, audio file, or video, so you search for an online tool. The problem: many online conversion tools aren't safe to use, putting you at risk from malware ...

Well, PowerShell itself doesn’t come with a feature to allow you to convert your files. Instead, you will need to use third-party popular tools like FFmpeg and HandBrakeCLI. A lot will also depend on ...

Community driven content discussing all aspects of software development from DevOps to design patterns. It’s pretty easy to run a batch file on Windows. Just create a file, change the extension to ...

Have you ever found yourself staring at a PDF file, wishing you could just pull the data into Excel and get to work? Whether it’s a financial report, a client list, or a data-heavy table, PDFs can ...

An XLS file is the native spreadsheet file type for versions of Microsoft Excel prior to Excel 2007. A QIF file is a Quicken Interchange Format file. The QIF file format was originally established by ...