Search results 216

Sorted from new to old.

Shapes-Macros

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

2018Jul9

Import_CSV

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

2018Jul7

DuplicateFileName

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

2018Jul7

FileDateTime

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

2018Jul5

PI

Returns a double representing the mathematical constant Pi

2018Jul5

GetTempFileName

Returns temp file name using FSO

2018Jul2

SharePointURL2Path + Path2SharePointURL

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

2018Jun30

DeleteAllFiles

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

2018Jun30

DownloadFile_User

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

2018Jun30

FormulasFlatten

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

2018Jun30

Distance_Calc_fromString

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

2018Jun27

DelOldFiles

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

2018Jun24

FS_CopyFile

Copies a file

2018Jun24

GetPapa

Gets folder name of a page using FSO

2018Jun24

DosCommand_Read

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

2018Jun22

ASCII_Read + ASCII_Save

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

2018Jun21

1 2 ...11 ...13 14