Search results 168

Sorted from new to old.

Open different Filestypes

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

2019Jan9

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

MSSQL backup

The practical way I found to backup database (or tables) to be moved into new ...

2019Jan6

Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

2019Jan1

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

1 2 ...9 10 11