Search results 58

Sorted from new to old.

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Sep10

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

Jul26

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

Jul15

Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

2023Dec27

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

Thin HTML5 Coming soon Template

Simple, elegant, thin template for Under Contruction site. Found it in my ...

2023Aug19

O365 Blocked Macros

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

2023Jul10

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

1 2 3 4