Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel COLUMN Function
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Excel Advanced Lookup using Index and Match Functions
  • To count total rows in a range in Excel
  • How to get relative column numbers in a range in Excel

Data Analysis Examples

  • How To Perform and Interpret Regression Analysis in Excel
  • Excel Line Chart
  • How to Sort by Color in Excel
  • Get column index in Excel Table
  • How to create running total in an Excel Table

Data Validation Examples

  • Excel Data validation require unique number
  • Excel Data validation date in specific year
  • Excel Data validation specific characters only
  • Excel Data validation allow uppercase only
  • Excel Data validation allow weekday only

Path and FullName property in Excel VBA

by

The Path property in Excel VBA returns the complete, saved path to the workbook (Excel file). The FullName property in Excel VBA returns the complete, saved path, including the name of the workbook.

Download path-fullname.xls and add it to “C:\test\”

Place a command button on your worksheet and add the following code lines:

1. The following code line returns the complete path to path-fullname.xls.

MsgBox Workbooks("path-fullname.xls").Path

Result:

2. The following code line returns the complete path, including the name of the active workbook.

MsgBox ActiveWorkbook.FullName

Result:

Post navigation

Previous Post:

Close and Open Excel Workbooks Through VBA

Next Post:

Loop through Books and Sheets Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to compare two text strings in Excel
  • How to Check If A Cell Contains Specific Text in Excel
  • How to check if cell contains number in Excel
  • Change Case: Uppercase, Lowercase, Propercase in Excel
  • How to strip protocol and trailing slash from URL in Excel
  • How to join date and text together in Excel
  • TODAY function: Description, Usage, Syntax, Examples and Explanation
  • Display Days until expiration date in Excel
  • Calculate years between dates in Excel
  • Get date from day number in Excel
  • How to calculate present value of annuity in excel
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
  • Calculate periods for annuity in Excel
  • Future value vs. Present value examples in Excel
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles