Search results 122

Sorted from new to old.
Card image
Progress in two nested loops

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

Card image
ANStr2Range

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

Card image
HyperlinkFunction

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

Card image
ASP Classic Page Cache

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

Card image
DBTables

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

Card image
OpenAnyFile

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

Card image
Tabindex in multipage

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

Card image
CSVs2Sheets

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

Card image
Highlight row of current month

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

Card image
Execute exe embedded in Excel

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

Card image
ShapeRange_BG

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

Card image
Card image
ToolPath

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

Card image
EnvironList

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

Card image
Generate_PowerPoint

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

Card image
Wrong file permissions

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