updated: | 2022 03. November |
published: | 2021 08. September |
Visualbasic Codeschnipsel
Ein paar Visualbasic Codeschnipsel für Microsoft OfficeExcel 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