Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/dbswav/public_html/excelwithkenan.com/goster_hazir_makrolar.php:61) in /home/dbswav/public_html/excelwithkenan.com/header.php on line 2

Excel Free Macros (VBA)

---

Specifies The Path And Name Of The Book

Online Excel and Excel Macro (VBA) Courses

Copy Macro 'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php Function FileOrFolderName(InputString As String, _ ReturnFileName As Boolean) As String Dim i As Integer, FolderName As String, FileName As String i = 0 While InStr(i + 1, InputString, Application.PathSeparator) > 0 i = InStr(i + 1, InputString, Application.PathSeparator) Wend If i = 0 Then FolderName = CurDir Else FolderName = Left(InputString, i - 1) End If FileName = Right(InputString, Len(InputString) - i) If ReturnFileName Then FileOrFolderName = FileName Else FileOrFolderName = FolderName End If End Function Sub TestFileOrFolderName() MsgBox FileOrFolderName(ThisWorkbook.FullName, False), , _ "This Workbook Foldername:" MsgBox FileOrFolderName(ThisWorkbook.FullName, True), , _ "This Workbook Filename:" End Sub

Report problem with this macro

This macro does not work.
There's an error in the code.
Other
You can write your comments about the error in the box below.

Report error

ALL MACROS Youtube Channel
The following macros may be useful for you.

Similar Results

No	Macro Name
1	Specifies the path and name of the book
2	desktop icon creation
3	excel operators hk
4	specifies in detail how many references the book contains (on new sheet / page)
5	specifies in detail how many formulas are in the book (on new sheet / page)
6	inserts months as sheet / pages Specifies days in detail
7	create shortcut to desktop
8	processes the opening date and time of the file in txt (bottom to bottom)
9	Attendance Codes workbook-level tasks & nbsp; it will help you perform it easily and with minimal effort. & Nbsp; Create a Backup of a Current Workbook: This is one of the most useful macros that can help you save a backup file of a current workbook. Saves a backup file in the directory where your current file is saved. & Nbsp; It will also add the name of the file to the current date.
10	prints the path and name of the file to the cell
11	show file path list in detail fields of files file path etcâ € ¦
12	save book you specify name - notifies you by message
13	Undo cells with 0
14	specify partition, list how many files you have
15	automatic custom footer and header information on sheet / pages
16	send alert e-mail from microsoft outlook
17	Can the characters typed in the inputbox appear as "*****" (password or password characters)?
18	printing and prompting
19	records detailed formatted cells on the records sheet / page
20	list formulas on new sheet / page

---

---

Online Excel Courses

Online Excel Courses are here...

Click to see

Services

• Advanced Excel Courses
• Excel Macro Courses
• Comporate Valuation Courses
• Financial Mathematics
• Financial Modeling
• Comporate Valuation Services

How can we help you?

You can contact us about our services.

Contact us

Subscribe to our Youtube Channel?

Here are the videos that will make your life easier using Excel.

Subscribe Now

Keywords

Excel Videos Advanced Excel Courses Free Macros Free Excel Templates Excel Macro Courses