Contents








Log


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 file
Closed 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
Copy loaded file
Copy 1 closed file
  Copy several closed files

Method: 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

Method: 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

Method: 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

Method: new TXT/CSV file
 
  New TXT/CSV file


DICTIONARIES, ARRAYS, COLLECTION




EXCEL















Workbook and VBProject
Modules

The contents of a module
Codemodule
Read the complete VBA code
Read part of the VBA code
Delete all code in the codemodule

Macromodule
Macro
All macros in a module
Macro search
Macro add
Macro read code
Macro copy
Macro replace code
Macro rename
Macro remove/delete
Macro move

Functions
All functions in a module
Function search
Function add
Functie read code
Function copy
Function replace code
Function rename
Function remove/delete
Function move

Workbook
Macros
Functions
Eventprocedures
All eventprocedures in a Workbook
Eventprocedure search
Eventprocedure read
Eventprocedure remove/delete
Eventprocedure add
Eventprocedure copy
Eventprocedure move

Worksheet
Macros
Functions
Eventprocedures
All Eventprocedures in a worksheet
Eventprocedure search
Eventprocedure read
Eventprocedure remove/delete
Eventprocedure add
Eventprocedure copy
Eventprocedure move

ActiveX-controls
All ActiveX-controls in a worksheet
Add ActiveX-control
Copy ActiveX-control
Rename ActiveX-control
Remove ActiveX-control
ActiveX-eventprocedure code
Search ActiveX eventprocedure code
Read ActiveX eventprocedure code
Add ActiveX eventprocedure code
Copy ActiveX eventprocedure code
Move ActiveX-eventprocedure code
Replace ActiveX eventprocedure code
Remove/delete ActiveX-eventprocedure code

Userform
Macros
Functions
Eventprocedures
All eventprocedures in a Userform
Search Eventprocedure
Read Eventprocedure
Remove Eventprocedure
Add Eventprocedure
Copy Eventprocedure
Move Eventprocedure
Control in Userform

Formcontrols
Add Formcontrol
Copy Formcontrol
Rename Formcontrol
Remove/delete Formcontrol
Formcontrol eventprocedures
All Formcontrol eventprocedure code of a single formcontrol
Find Formcontrol eventprocedure code
Read Formcontrol eventprocedure code
Add Formcontrol eventprocedure code
Copy Formcontrol eventprocedure code
Replace Formcontrol eventprocedure code
Adapt Formcontrol eventprocedure code
Remove/delete Formcontrol eventprocedure code

OUTLOOK



Standardfolders in Outlook
Summary standardfolders
Standarditems in Outlook
Summary standarditems

Email

Email drafts

Emails in folder PostOUT

Sent emails in folder Sent

Received emails in folder PostIN

Recipients

Distributionlist

Notes

Appointments

Meetingrequests

Tasks

Taskrequests

Journalitems

Posts