Search results 64

  2. Search results
  3. workbooks
Sorted from new to old.
Card image
CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9
Card image
WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9
Card image
WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

2018Aug9
Card image
CreateThumb_IrfanView

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

2018Jul22
Card image
WorkbookSaveAsk_ANmar

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

2018Jul17
Card image
WorkbookOpenAsk_ANmar

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

2018Jul17
Card image
FindFile

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

2018Jul11
Card image
Import_CSV

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

2018Jul7
Card image
SortArea1

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

2018Jul4
Card image
CellRead (SimpleLookup)

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

2018Jun25
Card image
RowsCount

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

2018Jun22
Card image
WorkbookOpen_ANmar

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

2018Jun16
Card image
FixPath, IsThere, IsThere1 ...

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

2018Jun11
Card image
FindName

Finds a name in a workbook, returns true or false

2018Jun10
Card image
FindSheet

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

2018Jun7
Card image
CountColumnCells + CountColumnCells_Criteria

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

2018May23
1234