How to get the path of current worksheet in VBA?

by

Use Application.ActiveWorkbook.Path for just the path itself (without the workbook name) or Application.ActiveWorkbook.FullName for the path with the workbook name.

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Read/Parse text file line by line in VBA
  3. How do I find the last column with data?
  4. Excel VBA: Answer gets “stuck”
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. filter out multiple criteria using excel vba
  9. Excel VBA autofilter all but three
  10. How can I create a calendar input in VBA Excel?
  11. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  12. Excel VBA code to copy a specific string to clipboard
  13. Merge values of column B based on common values on column A
  14. How to import a table from web page (with “div class”) to excel?
  15. Range limit conundrum
  16. How do you run a .exe with parameters using vba’s shell()?
  17. Excel VBA – Range.Copy transpose paste
  18. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  19. How to give a time delay of less than one second in excel vba?
  20. Changing the date format to yyyy-mm-dd
  21. Delete all duplicate rows Excel vba
  22. In Excel, can I use a hyperlink to run vba macro?
  23. Select Newest Record and Create New Table of Unique Values in Excel
  24. excel vba freeze pane without select
  25. How to delete rows in Excel based on criteria using VBA?
  26. Converting a string representation of a constant into a constant?
  27. Macro to export MS Word tables to Excel sheets
  28. Create folder path if does not exist (saving from VBA)
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment