ANmarAmdeen

Card image
Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

Card image
CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Card image
CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

Card image
FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

Card image
Excel clipboard bug

Looks like there is a bug in Excel when dealing with copy and paste. Excel ...

Card image
Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

Card image
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

Card image
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Card image
ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

Card image
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

Card image
ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

Card image
Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

Card image
Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

Card image
VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

Card image
PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

Card image
SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.