Search results 332

Sorted from new to old.

WorkbookOpen_ANmar

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

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11

DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

FileDate_Formatted

Using FileDateTime to get file date

2018Jun10

Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10

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

ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

2018Jun6

Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...

2018May29

CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29

1 2 ...20 21