Search results 148

Sorted from new to old.
Card image
WorkbookSaveAsk_ANmar

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

Card image
WorkbookOpenAsk_ANmar

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

Card image
FindFile

Finds if a workbook is open or not in same Excel session

Card image
Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

Card image
FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

Card image
XLThumbView

Showing thumbnails inside sheet and enlarging each when click

Card image
Error_Raise

To raise a friendly error message with option to show custom error number and ...

Card image
FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

Card image
Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

Card image
XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

Card image
Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

Card image
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

Card image
CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

Card image
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

Card image
ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

Card image
RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...