Search results 295

Sorted from new to old.

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

ImgDimensions

Reads image dimensions, width, height, depth and image type. Details returned ...

Jan16

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Jan15

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns

Jan13

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

Jan12

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

Jan11

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

Jan9

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

Jan8

Protect txt file into word doc with password

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

Jan4

FontAwesome Custom icons issue

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

2023Dec29

Frm58

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

2023Dec25

ChartLabelsNumberFormat

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

2023Dec23

ANmaPivotTable_Clear

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

2023Dec22

ChartLegendCenter

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

2023Dec21

Macro keyboard shortcuts

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

2023Dec13

1 2 3 ...18 19