Hopefully my illustration describes why I'm baffled by this issue:
DatePuzzle-01.jpg
I've shown the import macro below in full. But the problem must arise in the first section, before calling the other three macros which further manipulate the imported text.
It's almost as if Excel's Import Wizard ignores regional settings and uses the USA standard. And I'm almost certain this was working smoothly a few days ago... Could it be yet another Win 10 WU issue?Please Login or Register to view this content.
I've spent hours trying in vain to see what's wrong, so help would be much appreciated please!
Bookmarks