ronknight ronknight

Developer by day, Programmer by night, System Analyst by profession, and fueled by coffee.

ronknight / ConsoleHost_history.txt

Created December 19, 2024 23:59

Clear Terminal History Windows 11

C:\Users\YOUR_USERNAME\AppData\Roaming\Microsoft\Windows\PowerShell\PSReadLine\ConsoleHost_history.txt

ronknight / ExtractItemNumbers.xlsm

Created February 5, 2025 19:40

Macro to get all item numbers from 4sgm URL

	' Require 4sgm item numbers on column A
	' Require URL with 100 per page parameter
	' Enter URL when prompted


	Sub ExtractItemNumbers()
	Dim ie As Object
	Dim html As Object
	Dim skuElements As Object
	Dim skuElement As Object

ronknight / InsertImagesForAllRows.xlsm

Created February 5, 2025 19:44

Macro to Insert Images For All Rows

	' Require Item numbers on Column A
	' Enter base path when prompted

	Sub InsertImagesForAllRows()
	Dim ws As Worksheet
	Dim imgPath As String
	Dim imgCell As Range
	Dim lastRow As Long
	Dim i As Long
	Dim basePath As String

ronknight / InsertImageToExcel.xls

Created February 5, 2025 19:47

Excel formula to add image to cell