Christopher Kibble's Technical Ramblings
  • Updated PingCell Function for Excel

    2009-08-24 VBA Excel

    This post was previously released under a different blog and is being republished by me below. That site is no longer available. I am the original author. I’ve updated my Microsoft Excel PingCell code that I published previously. The new function returns all results from Win32_PingStatus back to Excel. You can now ping …

    Read More
  • Generating a List of Values in Excel (VBA)

    2009-05-09 Excel VBA

    I frequently find myself needing to create lists of values I have in Excel in one cell. For example, I might get have a column of IDs and I need to create a comma delimited list of them to put into a SQL Query. I have the following function I put in an XLA that loads with Excel to generate these lists. 1Public Function …

    Read More

Chris Kibble

Technologist, PowerShell, Desktop Engineering, SQL.

Recent Posts

  • Setup Google Cloud Certificate Authority - Part 2
  • Standing Up a Microsoft Certificate Authority - Part 8
  • Setup Google Cloud Certificate Authority - Part 1
  • Standing Up a Microsoft Certificate Authority - Part 7

Categories

CONFIGURATION-MANAGER 19 PKI 9 POWERSHELL 9 SYSTEMS-ADMINISTRATION 9 TROUBLESHOOTING 8 CONFERENCES 5 APPLICATION-PACKAGING 4 MSOFFICE 3 DOMAINS-AND-HOSTING 2 MCAFEE-ENDPOINT-ENCRYPTION 2
All Categories
ACTIVE-DIRECTORY1 APPLICATION-PACKAGING4 CONFERENCES5 CONFIGURATION-MANAGER19 DOMAINS-AND-HOSTING2 EXCEL1 GEEKING-OUT1 GOOGLE1 IPHONE1 JAVA1 MCAFEE-ENDPOINT-ENCRYPTION2 MICROSOFT-DOCS1 MSDOCS1 MSOFFICE3 NINITE1 PKI9 POWERSHELL9 SYSTEMS-ADMINISTRATION9 TROUBLESHOOTING8 WINDOWS-101 YNAB2
[A~Z][0~9]

Series

STANDING-UP-A-CERTIFICATE-AUTHORITY 8 VIDEOS 4 STANDING-UP-A-GOOGLE-CERTIFICATE-AUTHORITY 2

Tags

CONFIGMGR 19 POWERSHELL 15 MSOFFICE 10 SQL 9 CA 8 PKI 8 MMS 7 EXCEL 6 GOOGLE 4 AUTOIT 3
All Tags
ACROBAT1 ANKER1 AUTOIT3 BATCH1 CA8 CHROME2 CITRIX1 CONFIGMGR19 DOMAINS2 EDGE1 EXCEL6 FLASH1 GITHUB2 GOOGLE4 IPHONE2 JAVA1 MMS7 MOPHIE1 MSDOCS1 MSIEXEC1 MSOFFICE10 NAS1 NINITE1 NOTEPAD++1 PKI8 POWERSHELL15 SAFEBOOT2 SCCM1 SKYPE1 SONOS1 SQL9 SYNOLOGY1 TRAVEL1 VAMT1 VBA2 VISIO1 VMWARE1 WINDIRSTAT1 WINDOWS-103 YNAB2
[A~Z][0~9]