Search results 127

Sorted from new to old.

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

2021Feb24

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

GenerateThumbnail.php

Generates thumbnail of an image and saving it in certain folder. Edit php to ...

2020Dec24

1 2 3 ...7 8