Search results 53

Sorted from new to old.

Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

2019Jan9

PrettyPath

Formats a path for use in user displays, trim it beautifully. PrettyPath is ...

2018Sep23

RmDir

Delete a folder, expects to be an empty folder, path must be already MapPathed

2018Sep5

UnMappath

Returns the virtual path of the absolute path specified in the required ...

2018Aug26

IsThere1_Folder

Checks if a folder is found or not, can pass either mapped path or unmapped ...

2018Aug10

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

2018Aug3

GetRelativePath

Get relative path of one to another Pass two path strings to this function and ...

2018Jul19

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

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

SharePointURL2Path + Path2SharePointURL

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

2018Jun30

IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

2018Jun18

BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16

FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

1 2 3 4