Search results 28

Sorted from new to old.
Card image
Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

Card image
Execute exe embedded in Excel

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

Card image
NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

Card image
Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

Card image
LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

Card image
UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

Card image
Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

Card image
Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

Card image
CapitalizeAllWords

Capitalize first letter in all words In a String

Card image
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

Card image
oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

Card image
WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...