Search results 82

Sorted from new to old.

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

Nautical/Flight Functions

Functions perform various calculations useful for planning trips. MPH2Kt: ...

2020Oct13

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

Functions.dll

Old DLL housing list of functions to be used and called by any application, ...

2020Jul18

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

ProtectFile_XorD + UnProtectFile_XorD

Protects and unprotects a file using password Creates another copy of the file ...

2020Jan10

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

ANmaRedirect_Plus1

Function to log the redirects that happen into website It is merely used with ...

2019Oct25

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

1 2 3 ...5 6