Use Local Date Format When Opening CSV In VBA (There's A Catch)
If your macro needs to open a CSV you may notice it treats the dates as US format and this may causes issues. In today's video I show how to override this behaviour so it uses your local format instead. Even if you already know how, keep watching as there is an exception and I'll talk about that as well.
Excel Version
Recorded using Excel Pro Plus 2021 but also works with Microsoft 365
You cannot run VBA/Macros directly in Excel online
Excel Tips Playlist
• EXCEL TIPS