This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
vba:index [29.04.2015 10:35:31] yaslaw |
vba:index [16.10.2015 11:46:56] (current) yaslaw |
||
---|---|---|---|
Line 1: | Line 1: | ||
~~DISCUSSION:off~~ | ~~DISCUSSION:off~~ | ||
- | ~~NOCACHE~~ | + | ~~NOCACHE~~ |
====== VBA ====== | ====== VBA ====== | ||
- | Hier sammeln sich diverse Scripts, Funktionen und Anderes rund um Visual Basic for Applications (VBA). | + | //Diverse Scripte, Funktionen, Klassen und Tutorials rund um VBA// |
- | \\ Die Sammlung ist auch für mich, damit ich in verschiedenen Projekten auf meine Funktionen/Scripte Zugriff habe. | + | |
+ | Eine sammeln sich diverse Scripts, Funktionen und Anderes rund um Visual Basic for Applications (VBA). | ||
+ | Die Sammlung ist auch für mich, damit ich in verschiedenen Projekten auf meine Funktionen/Scripte Zugriff habe. | ||
Darum ist auch nicht alles Dokumentiert und nicht jede Funktion macht per se Sinn. | Darum ist auch nicht alles Dokumentiert und nicht jede Funktion macht per se Sinn. | ||
+ | Für die Ausgabe der Testresultate verwende ich in den meisten Fällen meine [[vba:functions:print_r:index|print_r() Funktion]]. | ||
+ | |||
+ | ===== Allgemein ===== | ||
- | ===== Inhalt ===== | + | ==== Tutorials ==== |
+ | [[vba:tutorials:index]] zum Thema VBA. Diese sind nicht speziefisch Programmabhängig | ||
- | ~~NOCACHE~~ | ||
- | <html><div class="pagequery " style="font-size:100%"><h1 class="title"></html> | ||
- | [[vba:tutorials:index]] | ||
- | <html></h1></div></html> | ||
{{pagequery> | {{pagequery> | ||
^vba:tutorials:(?!index)[^:]+(?::index)?$; | ^vba:tutorials:(?!index)[^:]+(?::index)?$; | ||
Line 18: | Line 20: | ||
sort=ns:asc,title:asc; | sort=ns:asc,title:asc; | ||
display=title; | display=title; | ||
- | snippet=plain,1,l1; | + | snippet=inline,999999,l1; |
bullet=square; | bullet=square; | ||
fontsize=100%; | fontsize=100%; | ||
Line 25: | Line 27: | ||
}} | }} | ||
- | <html><div class="pagequery " style="font-size:100%"><h1 class="title"></html> | + | ==== Allgemein ==== |
- | Allgemein | + | Ganz allgemeine Code-Schnipsel & Überlegungen |
- | <html></h1></div></html> | + | |
{{pagequery> | {{pagequery> | ||
@vba: *; | @vba: *; | ||
Line 34: | Line 36: | ||
display=title; | display=title; | ||
hidestart; | hidestart; | ||
- | snippet=plain,all,w15; | + | snippet=inline,999999,l1; |
bullet=square; | bullet=square; | ||
fontsize=100%; | fontsize=100%; | ||
hidemsg; | hidemsg; | ||
hidejump; | hidejump; | ||
- | layout=column; | ||
}} | }} | ||
- | /* Classes */ | + | ==== Klassen ==== |
- | <html><div class="pagequery " style="font-size:100%"><h1 class="title"></html> | + | [[vba:classes:index|Liste der Klassen]] |
- | [[vba:classes:index]] | + | |
- | <html></h1></div></html> | + | |
{{pagequery> | {{pagequery> | ||
Line 52: | Line 51: | ||
sort=ns:asc,title:asc; | sort=ns:asc,title:asc; | ||
display=title; | display=title; | ||
- | snippet=plain,all,w15; | + | snippet=inline,999999,l1; |
bullet=square; | bullet=square; | ||
fontsize=100%; | fontsize=100%; | ||
hidemsg; | hidemsg; | ||
hidejump; | hidejump; | ||
- | layout=column; | ||
}} | }} | ||
- | /* Functions */ | + | ==== Funktionen ==== |
- | <html><div class="pagequery " style="font-size:100%"><h1 class="title"></html> | + | [[vba:functions:index|Liste der Funktionen]] |
- | [[vba:functions:index]] | + | |
- | <html></h1></div></html> | + | |
{{pagequery> | {{pagequery> | ||
^vba:functions:(?!index)[^:]+(?::index)?$; | ^vba:functions:(?!index)[^:]+(?::index)?$; | ||
fullregex; | fullregex; | ||
- | sort=ns:asc,title:asc; | + | sort=title:asc; |
display=title; | display=title; | ||
- | snippet=plain,all,w15; | + | snippet=inline,999999,l1; |
bullet=square; | bullet=square; | ||
fontsize=100%; | fontsize=100%; | ||
hidemsg; | hidemsg; | ||
hidejump; | hidejump; | ||
- | layout=column; | ||
}} | }} | ||
- | /* Cast */ | + | ==== Cast ==== |
- | <html><div class="pagequery " style="font-size:100%"><h1 class="title"></html> | + | [[vba:cast:index|Liste der Cast-Funktionen]] |
- | [[vba:cast:index]] | + | |
- | <html></h1></div></html> | + | |
{{pagequery> | {{pagequery> | ||
Line 88: | Line 81: | ||
sort=ns:asc,title:asc; | sort=ns:asc,title:asc; | ||
display=title; | display=title; | ||
- | snippet=plain,all,w15; | + | snippet=inline,999999,l1; |
bullet=square; | bullet=square; | ||
fontsize=100%; | fontsize=100%; | ||
hidemsg; | hidemsg; | ||
hidejump; | hidejump; | ||
- | layout=column; | ||
}} | }} | ||
- | /* MS Access */ | + | ===== MS Access ===== |
- | <html><div class="pagequery " style="font-size:100%"><h1 class="title"></html> | + | [[vba:access:index|VBA Funktionen, Klassen & Scripte rund um MS Access]] |
- | [[vba:access:index]] | + | |
- | <html></h1></div></html> | + | |
{{pagequery> | {{pagequery> | ||
^vba:access:(?!index)[^:]+(?::index)?$; | ^vba:access:(?!index)[^:]+(?::index)?$; | ||
Line 105: | Line 95: | ||
sort=ns:asc,title:asc; | sort=ns:asc,title:asc; | ||
display=title; | display=title; | ||
- | snippet=plain,all,w15; | + | snippet=inline,999999,l1; |
bullet=square; | bullet=square; | ||
fontsize=100%; | fontsize=100%; | ||
hidemsg; | hidemsg; | ||
hidejump; | hidejump; | ||
- | layout=column; | ||
}} | }} | ||
- | /* MS Excel */ | + | ==== Funktionen ==== |
- | <html><div class="pagequery " style="font-size:100%"><h1 class="title"></html> | + | {{pagequery> |
- | [[vba:excel:index]] | + | ^vba:access:functions:(?!index)[^:]+(?::index)?$; |
- | <html></h1></div></html> | + | fullregex; |
+ | sort=ns:asc,title:asc; | ||
+ | display=title; | ||
+ | snippet=inline,999999,l1; | ||
+ | bullet=square; | ||
+ | fontsize=100%; | ||
+ | hidemsg; | ||
+ | hidejump; | ||
+ | }} | ||
+ | |||
+ | ==== Klassen ==== | ||
+ | {{pagequery> | ||
+ | ^vba:access:classes:(?!index)[^:]+(?::index)?$; | ||
+ | fullregex; | ||
+ | sort=ns:asc,title:asc; | ||
+ | display=title; | ||
+ | snippet=inline,999999,l1; | ||
+ | bullet=square; | ||
+ | fontsize=100%; | ||
+ | hidemsg; | ||
+ | hidejump; | ||
+ | }} | ||
+ | |||
+ | |||
+ | |||
+ | ===== MS Excel ===== | ||
+ | [[vba:excel:index|VBA Funktionen, Klassen & Scripte rund um MS Excel]] | ||
{{pagequery> | {{pagequery> | ||
@vba:excel: *; | @vba:excel: *; | ||
Line 122: | Line 138: | ||
display=title; | display=title; | ||
hidestart; | hidestart; | ||
- | snippet=plain,all,w15; | + | snippet=inline,999999,l1; |
bullet=square; | bullet=square; | ||
fontsize=100%; | fontsize=100%; | ||
hidemsg; | hidemsg; | ||
hidejump; | hidejump; | ||
- | layout=column; | ||
}} | }} | ||