Search results 990

Sorted from new to old.

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

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

Thumbnail generator

Generates thumb image file from a jpg, gif or png, saves it to server, or show ...

2019Jan7

Embed fonts in Word doc

Embed fonts used in document, to make it available on any machine

2019Jan7

Shrinking DB

Steps to shrink database in MS SQL

2019Jan6

MSSQL backup

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

2019Jan6

OpenOffice Calc

OpenOffice programming with Visual Basic Some document I had for my reference.

2019Jan5

CTRL+K,C

Comment and de-comment lines quickly in VBE Create shortcuts inside VBE to ...

2019Jan5

FormatPhoneNumber

Formats a given 10 digit number into a nice looking phone number

2019Jan5

FormatMyDate

Formats a date, equivalent to VB6 function 'Format' Also with it, you will ...

2019Jan4

SSTree

Tree code, driven by Access DB A code I found somewhere online that I enhanced ...

2019Jan3

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

2019Jan3

Fancybox v2 apply

Applying Fancybox v2 from (

2019Jan2

Shortcuts (rundll32.exe)

Shortcuts to do certain commands in Windows (tested in Windows 7) Shutdown, ...

2019Jan1

Protect VBA

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

2019Jan1

1 2 ...43 ...61 62