Contents

Log


2016-10-05
ArrayList

2016-08-24
Collection

2016-01-19
Arrays and Excelformulae

2015-03-04
Autofilter

2014-11-04
New alphabetical Index

2014-10-15
Arrays

2014-08-19
Application.OnTime


GENERAL


Loaded fileClosed file

Properties
 
Name: fullname; drive + path + name + extension Name: fullname; drive + pad + name + extension
Name: name + extension Name: name + extension
Name: name without extension Name: name without extension
Name: extension Name: extension
Name: VBA name  
Name: DOS - name Name: DOS - name
Name: DOS - fullname Name: DOS - fullname
Path: full path without slash, unless in a rootdirectory Path: full path without slash, unless in a rootdirectory
Path: foldername without path Path: foldername without path
Drive: drivename Drive: drivename
Drive: drivenumber Drive: drivenumber
Drive: driveletter + : Drive: driveletter + :
Drive: free space on filecontaining drive Drive: free space on filecontaining drive
Application  
Type Type
Filetype  
Size: filesize / filelength in bytes Size: filesize / filelength in bytes
Size: filesize in kbytes Size: filesize in kbytes
Size: filesize in Mbytes Size: filesize in Mbytes
Attribute: VBA constant Attribute: VBA constant
Attribute: Character Attribute: Character
Attribute: readonly  
Date/time: file created Date/time: file created
Date/time: file last accessed Date/time: file last accessed
Date/time: last modified Date/time: last modified
Date/time: last printed  
Link Link
Browsable Browsable
File File
Folder Folder
File exists File exists
Status Status
Owner Owner
Version Version
Program description Program description
Description Description
File Version File Version
Product Name Product Name
Product Version Product Version
Title Title
Subject Subject
Author Author
Keywords  
Comments Comments
Template  
Last author  
Revision number  
Security  
Category Category
Format  
Manager  
Company Company
Hyperlink base  

Word and Powerpoint files
 
Total editing Time 
Number of Paragraphs 

Word files
 
Number of Words  
Number of Pages Number of Pages
Number of Lines 
Number of Characters 
Number of Characters with spaces 

Powerpoint Files
 
Number of Slides 
Number of comments 
Number of hidden Slides 
Number of Multimediaclips 

Music Files
 
Copyright Copyright
Artist Artist
Album Title Album Title
Year Year
Track Number Track Number
Genre Genre
Duration Duration
Bitrate Bitrate
Protected Protected
Audio Sample Size Audio Sample Size
Sample Rate Sample Rate
Channels Channels

Photo files
 
Camera Model Camera Model
Date Picture taken Date Picture taken
Dimensions Dimensions
Pixels horizontally Pixels horizontally
Pixels vertically Pixels vertically


Loaded fileUnloaded file

Methods
 

Copy file
 
Copy loaded file
Copy 1 closed file
  Copy several closed files

Move file
 
Move open file
Move 1 closed file to another folder
  Move 1 closed file within the same folder
  Move several closed files to another folder
  Move several closed files within the same folder

Method: delete/remove file
 
  Delete/remove 1 closed file
  Delete/remove several closed files

New Excel file
 
  New visible Excel file in existing Excel instance
  New invisible Excel file in existing Excel instance
  New invisible Excel file in new Excel instance

New Word file
 
  New visible Word file in existing Word instance
  New invisible Word file in existing Word instance
  New invisible Word file in new Word instance

New TXT/CSV file
 
  New TXT/CSV file



DICTIONARY, ARRAY, COLLECTION, ARRAYLIST





EXCEL

















1 Workbook and VBProject

2 Modules
2.1 Refer to a module
2.2 Inventory modulenames

2.3 Modulename adapt
2.3.1 Workbook
2.3.2 Worksheet
2.3.3 Userform
2.3.4 Macromodule
2.3.5 Classmodule

2.4 Module: add
2.4.1 Worksheet
2.4.2 Macromodule
2.4.3 Userform
2.4.4 Classmodule

2.5 Module: export
2.5.1 Macromodule
2.5.2 Userform
2.5.3 Worksheett
2.5.4 Classmodulet
2.5.5 Workbook
2.5.6 All modules

2.6 Module import
2.6.1 Worksheet
2.6.2 Macromodule
2.6.3 Userform
2.6.4 Classmodule
2.6.5 Workbook

2.7 Module: delete
2.7.1 Worksheet
2.7.2 Macromodule
2.7.3 Userform
2.7.4 Classmodule
2.7.5 All modules

2.8 Module: copy to file
2.8.1 Worksheet
2.8.2 Macromodule
2.8.3 Userform
2.8.4 Classmodule
2.8.5 All VBA modules

2.9 Modules: move to file
2.9.1 move within a book
2.9.2 Worksheet
2.9.3 Userform
2.9.4 Macromodule
2.9.5 Classmodule
3 Codemodule content

3.1 Codemodule
3.1.1 Complete VBA code
3.1.2 Part of VBA-code
3.1.3 Delete all VBA-code

3.2 Macromodule

3.2.1 Macro
3.2.1.1 inventory
3.2.1.2 find
3.2.1.3 add
3.2.1.4 read
3.2.1.5 copy
3.2.1.6 replace
3.2.1.7 rename
3.2.1.8 delete
3.2.1.9 move

3.2.2 Functions
3.2.2.1 inventory
3.2.2.2 find
3.2.2.3 add
3.2.2.4 read
3.2.2.5 copy
3.2.2.6 replace
3.2.2.7 rename
3.2.2.8 delete
3.2.2.9 move

3.3 Workbook
3.3.1 Macros
3.3.2 Functions
3.3.3 Eventprocedures
3.3.3.1 inventory
3.3.3.2 find
3.3.3.3 read
3.3.3.4 delete
3.3.3.5 add
3.3.3.6 copy
3.3.3.7 move

3.4 Worksheet
3.4.1 Macros
3.4.2 Functions
3.4.3 Eventprocedures
3.4.3.1 inventory
3.4.3.2 find
3.4.3.3 read
3.4.3.4 delete
3.4.3.5 add
3.4.3.6 copy
3.4.3.7 move

4 ActiveX controls

4.1 inventory

4.2 add
4.2.1 TextBox
4.2.2 OptionButton
4.2.3 CheckBox
4.2.4 Label
4.2.5 CommandButton
4.2.6 ToggleButton
4.2.7 SpinButton
4.2.8 ComboBox
4.2.9 ListBox
4.2.10 Frame
4.2.11 Tabstrip
4.2.12 MultiPage
4.2.13 ScrollBar
4.2.14 Image

4.3 copy

4.4 rename

4.5 delete

4.6 eventcode
4.6.1 eventcode: find
4.6.2 eventcode: read
4.6.3 eventcode: add
4.6.4 eventcode: copy
4.6.5 eventcode: move
4.6.6 eventcode: replace
4.6.7 eventcode: delete

5 Userform

5.1 Macros

5.2 Functions

5.3 Eventprocedures
5.3.1 inventory
5.3.2 find
5.3.3 read
5.3.4 delete
5.3.5 add
5.3.6 copy
5.3.7 move

5.4 Controls in a Userform
5.4.1 inventory

5.4.2 add
5.4.2.1 TextBox
5.4.2.2 OptionButton
5.4.2.3 CheckBox
5.4.2.4 Label
5.4.2.5 CommandButton
5.4.2.6 ToggleButton
5.4.2.7 SpinButton
5.4.2.8 ComboBox
5.4.2.9 ListBox
5.4.2.10 Frame
5.4.2.11 Tabstrip
5.4.2.12 MultiPage
5.4.2.13 ScrollBar
5.4.2.14 Image

5.4.3 copy

5.4.4 rename

5.4.5 delete

5.4.6 Userformcontrol events
5.4.6.1 inventory
5.4.6.2 find
5.4.6.3 read
5.4.6.4 add
5.4.6.5 copy
5.4.6.6 replace
5.4.6.7 adapt
5.4.6.8 delete

OUTLOOK


1 Access to Outlook
1.1.1 Not loaded: CreateObject
1.1.2 Outlook loaded: Getobject
1.1.3 Load Outlook-VBA-library

1.2 Defaultfolders in Outlook
1.2.1 Inventory of folders

1.3 Standarditems in Outlook
1.3.1 Inventory of standard items

2 VBA commands in Outlook
2.0 Email properties

3 Email-drafts
3.1.1 New email draft
3.1.2.1 to several addresses
3.1.2.2 to several CC-addresses
3.1.2.3 to several BCC-addresses
3.1.3.1 add TO recipients
3.1.3.2 add CC recipients
3.1.3.3 add BCC recipients
3.1.4 add attachments
3.2.1 read
3.2.2 move
3.2.3 delete
3.2.4 adapt
3.3.1 filter and read
3.3.2 filter and move
3.3.3 filter and delete
3.3.4 filter and adapt
3.4.1 find and read
3.4.2 find and move
3.4.3 find and delete
3.4.4 find and adapt

4 Emails in PostOUT
4.1 New email
4.1.1 New email with HTML
4.2.1 read
4.2.2 move
4.2.3 delete
4.2.4 adapt
4.3.1 filter and read
4.3.2 filter and move
4.3.3 filter and delete
4.3.4 filter and adapt
4.4.1 find and read
4.4.2 find and move
4.4.3 find and delete
4.4.4 find and adapt

5 Sent emails
5.1 read
5.2.2 move
5.2.3 delete
5.2.4 adapt
5.3.1 filter and read
5.3.2 filter and move
5.3.3a delete using a loop
5.3.3 filter and delete
5.3.4 filter and adapt
5.4.1 find and read
5.4.2 find and move
5.4.3 find and delete
5.4.4 find and adapt

6 Received emails
6.2.1 read
6.2.2 move
6.2.3 delete
6.2.4 adapt
6.3.1 filter and read
6.3.2 filter and move
6.3.3 filter and delete
6.3.4 filter and adapt
6.4.1 find and read
6.4.2 find and move
6.4.3 find and delete
6.4.4 find and adapt

7 Contacts
7.0 Contactitem properties
7.1 New Contact
7.2.1 read
7.2.5 information save as file
7.2.2 move
7.2.3 delete
7.2.4 adapt
7.3.1 filter and read
7.3.2 filter and move
7.3.3 filter and delete
7.3.4 filter and adapt
7.4.1 find and read
7.4.2 find and move
7.4.3 find and delete
7.4.4 find and adapt

8 Distributionlist
8.0 Distributionlist properties
8.1 New distributionlist
8.2.1 read
8.2.2 move
8.2.3 delete
8.2.4 adapt
8.3.1 filter and read
8.3.2 filter and copy
8.3.2 filter and move
8.3.3 filter and delete
8.3.4 filter and adapt
8.4.1 find and read
8.4.2 find and move
8.4.3 find and delete
8.4.4 find and adapt
8.5.1 read 1 contact
8.5.2 read all contacts
8.5.3 add contact
8.5.4 delete contact
8.5.5 delete contact: alt.
8.5.6 filter and delete contact

9 Notes
9.0 Note properties
9.1 New note
9.2.1 read
9.2.2 move
9.2.3 delete
9.2.4 adapt
9.3.1 filter and read
9.3.2 filter and move
9.3.3 filter and delete
9.3.4 filter and adapt
9.4.1 find and read
9.4.2 find and move
9.4.3 find and delete
9.4.4 find and adapt

10 Appointments
10.0 Appointment properties
10.1 New appointment
10.2.1 read
10.2.2 move
10.2.3 delete
10.2.4 adapt
10.3.1 filter and read
10.3.2 filter and move
10.3.3 filter and delete
10.3.4 filter and adapt
10.4.1 find and read
10.4.2 find and move
10.4.3 find and delete
10.4.4 find and adapt
10.4.5 find using several criteria

11 Meeting requests
11.0 Meeting request properties
11.1 New meeting request
11.2.1 read
11.2.2 move
11.2.3 delete
11.2.5 accept tentatively
11.2.6 accept
11.2.7 decline
11.3.1 filter and read
11.3.2 filter and move
11.3.3 filter and delete
11.3.5 filter, accept tentatively
11.3.6 filter and accept
11.3.7 filter and decline
11.3.8 filter and copy
11.4.1 find and read
11.4.2 find and move
11.4.3 find and delete
11.4.5 find, accept tentatively
11.4.6 find and accept
11.4.7 find and decline
11.4.8 find and copy

12 Tasks
12.0 Task properties
12.1 New task
12.2.1 read
12.2.2 move
12.2.3 delete
12.2.4 adapt
12.2.5 find several criteria
12.3.1 filter and read
12.3.2 filter and move
12.3.3 filter and delete
12.3.4 filter and adapt
12.4.1 find and read
12.4.2 find and move
12.4.3 find and delete
12.4.4 find and adapt

13 Taskrequests
13.0 Taskrequest properties
13.1 New taskrequest
13.2.1 read
13.2.2 move
13.2.3 delete
13.2.5 accept tentatively
13.2.6 accept
13.2.7 decline
13.3.1 filter and read
13.3.2 filter and move
13.3.3 filter and delete
13.3.4 filter and adapt
13.3.5 filter, accept tentatively
13.3.6 filter and accept
13.3.7 filter and decline
13.3.8 filter and copy
13.4.1 find and read
13.4.2 find and move
13.4.3 find and delete
13.4.4 find and adapt

14 Journalitems
14.0 Journalitem properties
14.1 New journalitem
14.2.1 read
14.2.2 move
14.2.3 delete
14.2.4 adapt
14.3.1 filter and read
14.3.2 filter and move
14.3.3 filter and delete
14.3.4 filter and adapt
14.4.1 find and read
14.4.2 find and move
14.4.3 find and delete
14.4.4 find and adapt
14.4.5 find

15 Post items
15.0 Postitem properties
15.1 New Post
15.1.1 New Post in specific folder
15.2.1 read
15.2.2 move
15.2.3 delete
15.2.4 adapt
15.3.1 filter and read
15.3.2 filter and move
15.3.3 filter and delete
15.3.4 filter and adapt
15.4.1 find and read
15.4.2 find and move
15.4.3 find and delete
15.4.4 find and adapt
15.4.5 find