Search results 62

Sorted from new to old.

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

2023Mar29

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

2021Dec6

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

2020Apr1

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

404 page

A nice simple 404 page with a game From

2020Feb16

Reset ID Column

How to reset ID Column in Microsoft SQL, (not completed yet). This is because ...

2020Feb9

1 2 3 4