Search results 216

Sorted from new to old.
Card image
Shapes-Macros

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

Card image
Import_CSV

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

Card image
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

Card image
FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

Card image
PI

Returns a double representing the mathematical constant Pi

Card image
GetTempFileName

Returns temp file name using FSO

Card image
SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

Card image
DeleteAllFiles

Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime

Card image
DownloadFile_User

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

Card image
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

Card image
Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

Card image
DelOldFiles

Delete files in a specified folder which are older than x days This code ...

Card image
FS_CopyFile

Copies a file

Card image
GetPapa

Gets folder name of a page using FSO

Card image
DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

Card image
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...