Search results 122

Sorted from new to old.

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

2021Dec6

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

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

Bing Desktop wallpapers

Folder where

2021Mar5

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

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

1 2 3 ...7 8