Search results 104

Sorted from new to old.

RangeTakePicture_Linked

Converts a range in Exce lsheet into picture. linked or unlinked. Important ! ...

Sep30

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

Sep30

ShapeDelete

Safely remove certain shape from worksheet

Sep30

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

Sep30

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

May30

MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

2024Aug15

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

2024Jul31

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

2024Apr30

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

SQL Cross Apply String_Split with XML Path

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

2024Jan20

SettingRead_Ajax + SettingRead_Ajax_IntoObject

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

2024Jan12

Protect txt file into word doc with password

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

2024Jan4

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

1 2 ...6 7