Recent codes added
Fresh codes added recently by our developers. 24 most recent codes.
.jpeg)
Hack VBE password in .xlsm
Remove VBE project password protection off of xlsm. This is screenshot on how ...
MergePDFsUsingPDFTK
Merges two PDF1 and PDF2 into PDFMerged, then delete PDF1 and PDF2 Using pdftk ...
ANStrColor2RGBA_Para
Returns Red, Green, Blue and Transparency from text representing color Like ...
Textbox_PartialBold
Set part of textbox to bold, starting from StartingChar (like : ) that found in ...
Pagebreak and Pagebreak preview
When setting the location of pagebreak, you need to have that sheet view set to ...
.jpeg)
Variable_PerLocation_FromFullLine
Extract set from ANstring, like 2nd set of variable list using specific ...
Formulas_FromFile_ToRow
Imports formulas from file into list of cells defined in file itself into ...
RangeTakePicture_Linked
Converts a range in Excel sheet into picture. linked or unlinked. Important! ...
ShapeCreate_SomeVariables
Create a shape in certain sheet with options Some other options are hard-coded, ...
.jpeg)
.jpeg)
ANmaUploadFTP_ANstrFilesto1Folder
Upload all files found in ANStr list of files into 1 folder. Passing all ...
Create Tree from 3 columns (Sheet2Tree)
Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...
CutString_JsonKeyValue
Reads value from json string for certain key. Using RegEx Regular Expression. ...
Icon as text - CmdCaption_ChrW
Creates an icon as text to use inside button or any frm20 controls. this will ...
Calculation_StaleValues
Show Stale function formats or hide Excel recently started to show cells with ...
