updated:  2022 03. November
published:  2021 08. September

Visualbasic Codeschnipsel

Ein paar Visualbasic Codeschnipsel für Microsoft Office

Excel Ordner ermitteln


Sub Vorlagenordner_Excel()

 MsgBox _ 
 "Current Path  - ActiveWorkbook.Path"         & vbNewLine & ActiveWorkbook.Path         & vbNewLine & vbNewLine & _
 "Standard Path - CurDir()"                    & vbNewLine & CurDir()                    & vbNewLine & vbNewLine & _
 "Vorlagen      - Application.TemplatesPath"   & vbNewLine & Application.TemplatesPath   & vbNewLine & vbNewLine & _
 "Programm      - Application.Path"            & vbNewLine & Application.Path            & vbNewLine & vbNewLine & _
 "Bibliothek    - Application.LibraryPath"     & vbNewLine & Application.LibraryPath     & vbNewLine & vbNewLine & _
 "Bibl. User    - Application.UserLibraryPath" & vbNewLine & Application.UserLibraryPath & vbNewLine & vbNewLine & _
 "Startordner   - Application.StartupPath"     & vbNewLine & Application.StartupPath

End Sub


Word Ordner ermitteln


Sub Vorlagenordner_Word()
 
 MsgBox _ 
 "Programm    - Application.Path"                         & vbNewLine & Application.Path            & vbNewLine & vbNewLine & _
 "Startordner - Application.StartupPath"                  & vbNewLine & Application.StartupPath     & vbNewLine & vbNewLine & _
 "Vorlagen    - ActiveDocument.AttachedTemplate.FullName" & vbNewLine & ActiveDocument.AttachedTemplate.FullName

End Sub


Stichworte (tags)