Search results 64

Sorted from new to old.

CreateThumb_IrfanView

Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...

2018Jul22

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

Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

2018Jul14

CreateZipFolder_7Zip

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

2018Jul14

FindFile

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

2018Jul11

Shapes-Macros

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

2018Jul9

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

FindName

Finds a name in a workbook, returns true or false

2018Jun10

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

1 2 3 4