VBA 149

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel

Sorted from new to old.

GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

2018Jun22

GetUTC

Get the time and date in Universal time based on local time Uses w32tm / tz ...

2018Jun22

DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

2018Jun22

AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

2018Jun20

DeleteTree

Deletes tree of files

2018Jun19

IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

2018Jun18

BinaryFile_Read + BinaryFile_Save

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

2018Jun18

DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

2018Jun18

ScreenRes

Reads screen resolution, using IE this time, this one will get the active ...

2018Jun17

EnvVar_All

Read all Environment variables using EnvDir_All Or quickly get user folder, or ...

2018Jun17

Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16

File_MostRecent

Getting most recent file in a folder

2018Jun16

WaitFor + ShellWait

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

2018Jun16

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11

1 2 ...8 9 10