Search results 172

Sorted from new to old.

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert them back ...

2020Nov11

Paste into textbox

Paste text from clipboard into textbox Needs Userform, textbox, commandbutton

2020Oct11

Input text - pre-Placeholder

Remove text when textbox is selected, then put it back if it left empty This ...

2020Oct10

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Window off-screen

Window not shown while taskbar says it is on. Restore window position in ...

2020Mar17

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

1 2 ...5 ...10 11