Search results 128

Sorted from new to old.

DateSerial

The equivalent of DateSerial in Classic ASP

2018Jul19

ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

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

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

HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30

UTF8R_toChar

Converts characters created by program R into actual chars as in < U+641 > to ...

2018Jun26

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

Hex2Dec

Converts hexadecimal strings into decimals

2018Jun20

1 2 ...7 8