Search results 201

Sorted from new to old.

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

2023Aug7

Bootstrap 5 color toggle

Working toggle button to switch between light and dark color modes in Bootstrap ...

2023Aug6

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

Excel user name

Get application user name or change it Originally from

2023Jun14

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19

1 2 3 ...12 13