Search results 181

Sorted from new to old.

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

UserSign

Returns someones astrology sign using their birthday in m/dd/yyyy or m/dd/yy ...

2018Aug8

CutString_Words_Left + CutString_Words_Mid

Cuts the left or Middle part of string without breaking words Can specify ...

2018Aug8

FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

2018Aug3

Textbox focus issue fix

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jul29

Ask4Folder

Asks user for a folder, starting with certain folder

2018Jul29

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

ANmAjax

Trying to simplifying applying AJAX in my websites and tools, this is the ...

2018Jul23

CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

2018Jul19

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

Capitalize1st

Capitalize 1st letter of a string

2018Jul15

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

CreateZipFolder_7Zip

Creates a zip from folder using 7Z archive. 7za.exe (found in attached zip) ...

2018Jul14

CutString1

Cuts a string from a string starting from a specific character index and until ...

2018Jul11

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

1 2 ...10 11 12