Search results 42

Sorted from new to old.

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

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

May4

DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Mar12

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

2024Mar4

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

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

PhotoViewer dll

Open image using legacy PhotoViewer from Windows 7 Command line call to use ...

2021Aug25

1 2 3