Boldcodes.com

ANmarAmdeen

Protect txt file into word doc with password

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

Jan4

CutString7

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

Jan1

CutLeftNumber

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

Dec31

FontAwesome Custom icons issue

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

Dec29

Excel clipboard bug

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

Dec27

Frm58

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

Dec25

ChartLabelsNumberFormat

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

Dec23

ANmaPivotTable_Clear

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

Dec22

ChartLegendCenter

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

Dec21

ANStrFind_AndOrAdd

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

Dec19

ReNumber_IDColumn_inTable

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

Dec17

Frequency1

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

Dec16

Macro keyboard shortcuts

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

Dec13

VBHTMLInstr

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

Dec3

PrCal_Add_Sort

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

Dec2

SQL Date from DateTime

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

Nov29

1 2 ...10 ...72 73