Search results 206

Sorted from new to old.

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

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

1 2 3 ...12 13