Difference between Thisworkbook.name and Activeworkbook.name in VBA

by

Activeworkbook.name is used to get the name of the active workbook from n different number of opened workbooks.

Thisworkbook.name is used to get the name of the workbook in which the code is written or stored in the module of that workbook.

E.g if you are writing the code in the module or sheet of workbook A then Thisworkbook.name will return A no matter which is the activeworkbook

More Related Contents:

  1. Loop through files in a folder using VBA?
  2. How to error handle 1004 Error with WorksheetFunction.VLookup?
  3. How can Excel VBA open file using default application
  4. How to compare two entire rows in a sheet
  5. Run same excel macro on multiple excel files
  6. VBA : save a file with UTF-8 without BOM
  7. Saving a Excel File into .txt format without quotes
  8. Excel VBA “Method ‘Document’ of object ‘IWebBrowser2’ failed”
  9. VBA – Range to jpg picture
  10. Fastest way to delete rows which cannot be grabbed with SpecialCells
  11. Combine multiple Excel workbooks into a single workbook
  12. Excel Macro, inserting internationally valid formula during run-time
  13. Making VBA Form TextBox accept Numbers only (including +, – and .)
  14. VBA Convert date to week number
  15. Inserting an Online Picture to Excel with VBA
  16. Change length of For loop while in the loop
  17. VBA – Run Time Error 1004 ‘Application Defined or Object Defined Error’
  18. Consolidating worksheets into one
  19. Copy filtered data to another sheet using VBA
  20. Range.Find on a Date That is a Formula
  21. Range() vs Cells() vs Range.Cells()
  22. Open an Excel file from SharePoint site
  23. mac excel vba loop : from list & then export as pdf
  24. Can Advanced Filter criteria be in the VBA rather than a range?
  25. In Excel VBA, what is the way to check if the web page is fully loaded?
  26. Excel Useform: How to hide application but have icon in the taskbar
  27. Calling regasm without administrative rights for COM interop in Excel VBA
  28. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  29. How do I activate a specific workbook and a specific sheet?
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment