GitHub

batch-insert-identical-excel-ole-object-into-multiple-word-files-using-a-foreach-loop.cs

// Folder where the Excel file to embed is located. string excelFilePath = Path.Combine(Environment.CurrentDirectory, "SampleData.xlsx"); // Ensure the Excel file ...
GitHub

batch-insert-the-same-excel-ole-object-into-multiple-word-documents-within-a-folder-using.cs

// Folder containing the source Word documents. string inputFolder = Path.Combine(Environment.CurrentDirectory, "InputDocs"); // Folder where the modified documents will be saved. string outputFolder ...
Redmond Magazine

Launching a PowerShell Script from Excel, Revisited

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 ...
Visual Studio Magazine

Access the Power of VB.NET From C#

And C# programmers are as happy as a kid with the newest toy on the block, mostly because they have the newest toy on the block. This is how things stand these days, midway through the "Everett" age. ...