Search results 164

Sorted from new to old.

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

2018Dec30

Global asa

As ASP Classic user, I have to have some post about global.asa Here is one, ...

2018Dec28

Application_OnStart

How to use Global.asa

2018Sep5

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

Base64encode + Base64decode

Encodes and decodes a string, Base64 is used to convert binary data (like ...

2018Jul31

Ask4Folder

Asks user for a folder, starting with certain folder

2018Jul29

Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

2018Jul14

CutString1

Cuts a string from a string starting from a specific character index and until ...

2018Jul11

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

DuplicateFileName

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

2018Jul7

FormulasFlatten

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

2018Jun30

UTF8R_toChar

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

2018Jun26

FS_CopyFile

Copies a file

2018Jun24

Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

2018Jun24

1 2 ...9 10 11