How to export file names from a folder to Excel using VBA

How often have we come across the situation where we had a set of folder with numerous files inside them, and we wanted to count the files quickly, and list their name on a Worksheet? Often I guess, pretty often. So here's a macro which let's you do the same, just by clicking a button.

Have you used XLOOKUP yet?

The whole purpose of XLOOKUP is to find one result, find it quickly, and return the answer to the spreadsheet.

- Joe McDaid, Excel Project Manager

Before I go into details about XLOOKUP, let me give you the bad news. XLOOKUP isn't available to the general public as of now. It is currently a beta feature, and only available to a portion of Office Insiders at this time. So unless you have enlisted with the Office Insider, you would be able to test the features of XLOOKUP yet, and Microsoft has not yet announced the XLOOKUP release date.

How to remove VBA Macro Password from Excel/Word/PowerPoint (Automatic Method)

In the previous post, we learned how to remove password from a VBA macro in Excel, PowerPoint, or Word (both 32- and 64-bit) the hard way. In this post we will talk about how to remove the password using another macro.

How to remove VBA Macro Password from Excel/Word/PowerPoint (Manual Method)

VBA macro Developers always add passwords to protect their work. If a client has reached out to you to develop a solution for them, it is obvious that you would add a password to protect it. Why? Because it is your intellectual property! If the client needs to modify the macro, they should ideally reach out to you again to do the same. You can even ensure even user-level access to your VBA macros so that the client cannot distribute it to users beyond what was agreed upon.

But what if you have forgotten the password you have set for the VBA macro that you created for your client? Recreating the macro is unrealistic in terms of budget and timeline. So what then?

How to Remove Workbook or Worksheet Password from Excel

Everyday we have to remember hundreds of passwords, both in our personal and professional lives. And it's only human to forget some of them every now and then, as long as we know how to retrieve those passwords or reset them. Resetting passwords for a web service like Gmail, or Facebook is easy. But what about a software, like Excel.

Excel has multi-level protection for it's users. You can add a password to protect the Workbook, Worksheets, you can even protect the VBA code inside the Excel Workbook with a password. If you forget one of these passwords, there is not normal way (like Gmail, or Facebook) to reset those password. Here we will discuss how to remove passwords from an Excel Workbook or Worksheet.