Microsoft Office Excel ® Kod Kılavuzu

Microsoft Office Excel® Code Guide

20 Temmuz 2003 Pazar

Path Information and Setting

'Module1

Sub Path_Information()
MsgBox "The Office Path is " & Application.Path
MsgBox "The Path Separator is " & Application.PathSeparator
MsgBox "The current default File Path is " & Application.DefaultFilePath
MsgBox "The ActiveWorkbook Path is " & Application.ActiveWorkbook.Path
MsgBox "The Alt StartUp Path is " & Application.AltStartupPath
MsgBox "The Library Path is " & Application.LibraryPath
MsgBox "The Network Templates Path is " & Application.NetworkTemplatesPath
MsgBox "The Startup Path is " & Application.StartupPath
MsgBox "The Templates Path is " & Application.TemplatesPath
MsgBox "The UserLibrary Path is " & Application.UserLibraryPath
MsgBox "The ThisWorkbook Path is " & Application.ThisWorkbook.Path
End Sub
Sub SetPath()
Application.AutoRecover.Path = "C:\"
End Sub


Hiç yorum yok:

Blog Arşivi

Bu gadget'ta bir hata oluştu

Bu Blogda Ara

Contributor

Contributor
Mustafa ULUSARAÇ İstanbul, TÜRKİYE
free counters
T. C. Central Bank Indicative Exchange Rates
Currency Exchange Rate Widget,Currency Converter Widget
Borsa İstanbul