Category "excel-365"

Excel Dynamic Array formula to create a running product of a column

I need to create a running product from a column of numbers (I could use a row, but a column is easier to demonstrate here.) The input might be any arbitrary a

workbooks.add fails when vbs-script is called from Task Scheduler

I have some code in VBscript that creates an excel object and adds a workbook to it Dim oExcel, oWB Set oExcel = CreateObject("excel.application") Set oWB =

How to get the locally formatted price out of these web pages

Microsoft has web pages showing the local prices for Windows in over 200 countries. For each country, there are separate web pages for Windows Pro, Windows Home

Find certain code combinations using text (sub)string in Power Query

I had similar question (link below), but it just lets say "add-on" to my issue that I found on the way. Find all code combinations using text string in Power Qu