Search results 54

Sorted from new to old.

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

2019Feb8

Language per app

Restore Windows 10 setting to remember language selected per application

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

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

DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

2018Dec25

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

Base64encode + Base64decode

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

2018Jul31

XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1

Ordinal

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

2018Jun24

BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18

ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

2018Jun17

WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

2018Jun16

FrmLarge v3

Shows an image after clicking on its thumbnail, like in web applications Can ...

2018May20

1 2 3 4