Hi Andrew, thanks for your reaction.
it appears to me that the string variable that I use in VBA can not hold the right filename in foreign format. It is not just the display of the variable, but the contents that is disturbed.
What I want to do is to rename/move the file into a private, standardised format and location depending on the contents.
The final renaming is done by means of a filecopy statement, but I can not successfully pass the "from" parameter to it by VBA.
Maybe there is a workaround, as Crystal suggested, to store the filname directly into a database and pass the "from:"parameter by means of a dlookup function. I will give that a try.
Kind regards, Onno
====================
You are correct, it has something to do with codepages and charactersets, and Unicode...
What you are seeing is the fact that although Windows is (mostly) Unicode aware and Access is (mostly) Unicode aware, there are some, quite a few actually, "got ya"s involved.
The situation was worse in Visual Basic, Access and VBA are better. VBA does support unicode strings, however, the VBA editor only allows VBA files to be encoded in the 8-bit codepage Windows-1252.
If you are lucky the only thing that will be wrong is that when you display the variable contents is that the font being used won't display the extended characters properly and you end up seeing a '?' for each character which the (non-unicode parts) cannot convert.
Depending on how you picked up the filename from the filesystem, the variable *should* hold the correct characters, even if the display on screen looks wrong.
__._,_.___
Posted by: onno.knol@pbl.nl
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar