Search results 141

Sorted from new to old.

WorkbookNew_ANmar

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

2018Aug9

WorkbookClose_ANmar

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

2018Aug9

LogFile_Add

Adds an entry to log file, if file is not exist, it will be created. Filename ...

2018Jul17

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

MP3GetInfo

Returning information on an MP3 file. Returns a type containing information ...

2018Jul11

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

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

FixENTERS_File

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

2018Jul7

Import_CSV

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

2018Jul7

DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

2018Jun30

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

BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18

1 2 ...8 9