First time post here...
I have a question, I'm using the functions Dir() and FileDateTime() to check if a file exists and the date of a certain file
Now this file has Japanese characters in it, I was able to change the settings in Windows so I can see the Japanese characters both in the folder where the files are located and in the VBA editor(I hard coded the file names) now whenever I run the tool VBA doesn't seem to be picking up the file in Dir() it's just blank and on FileDateTime() it says the file doesn't exist
I have a question, I'm using the functions Dir() and FileDateTime() to check if a file exists and the date of a certain file
Now this file has Japanese characters in it, I was able to change the settings in Windows so I can see the Japanese characters both in the folder where the files are located and in the VBA editor(I hard coded the file names) now whenever I run the tool VBA doesn't seem to be picking up the file in Dir() it's just blank and on FileDateTime() it says the file doesn't exist