Get upercase within String Value












0














I am currently working on a tool to automatically send out emails.
Within this tool one variable is the pathway in which the attachment is to be found.
The file names are automatically generated within a folder, but sometimes got strange symbols and/or uppercase letters, like this: "Sⁿkwrld.xlsx".
By collecting this value within a string, VBA retrieves: "Snkwrld.xlsx". This results in not being able to find the right file.



Is there a way to fix this problem and let VBA retrieve the correct value with the uppercase "N"?



Thanks in advance!



Best Regards,
Remco Coppens










share|improve this question


















  • 2




    Can be please post snippet of the code , you are using
    – Arul Suju
    Nov 13 '18 at 7:35










  • FWIW in what you show the n is not "uppercase". Uppercase n is N. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.
    – Cindy Meister
    Nov 13 '18 at 13:25










  • I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
    – R. Coppens
    Nov 13 '18 at 14:09


















0














I am currently working on a tool to automatically send out emails.
Within this tool one variable is the pathway in which the attachment is to be found.
The file names are automatically generated within a folder, but sometimes got strange symbols and/or uppercase letters, like this: "Sⁿkwrld.xlsx".
By collecting this value within a string, VBA retrieves: "Snkwrld.xlsx". This results in not being able to find the right file.



Is there a way to fix this problem and let VBA retrieve the correct value with the uppercase "N"?



Thanks in advance!



Best Regards,
Remco Coppens










share|improve this question


















  • 2




    Can be please post snippet of the code , you are using
    – Arul Suju
    Nov 13 '18 at 7:35










  • FWIW in what you show the n is not "uppercase". Uppercase n is N. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.
    – Cindy Meister
    Nov 13 '18 at 13:25










  • I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
    – R. Coppens
    Nov 13 '18 at 14:09
















0












0








0







I am currently working on a tool to automatically send out emails.
Within this tool one variable is the pathway in which the attachment is to be found.
The file names are automatically generated within a folder, but sometimes got strange symbols and/or uppercase letters, like this: "Sⁿkwrld.xlsx".
By collecting this value within a string, VBA retrieves: "Snkwrld.xlsx". This results in not being able to find the right file.



Is there a way to fix this problem and let VBA retrieve the correct value with the uppercase "N"?



Thanks in advance!



Best Regards,
Remco Coppens










share|improve this question













I am currently working on a tool to automatically send out emails.
Within this tool one variable is the pathway in which the attachment is to be found.
The file names are automatically generated within a folder, but sometimes got strange symbols and/or uppercase letters, like this: "Sⁿkwrld.xlsx".
By collecting this value within a string, VBA retrieves: "Snkwrld.xlsx". This results in not being able to find the right file.



Is there a way to fix this problem and let VBA retrieve the correct value with the uppercase "N"?



Thanks in advance!



Best Regards,
Remco Coppens







vba string text symbols uppercase






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 13 '18 at 7:33









R. CoppensR. Coppens

1




1








  • 2




    Can be please post snippet of the code , you are using
    – Arul Suju
    Nov 13 '18 at 7:35










  • FWIW in what you show the n is not "uppercase". Uppercase n is N. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.
    – Cindy Meister
    Nov 13 '18 at 13:25










  • I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
    – R. Coppens
    Nov 13 '18 at 14:09
















  • 2




    Can be please post snippet of the code , you are using
    – Arul Suju
    Nov 13 '18 at 7:35










  • FWIW in what you show the n is not "uppercase". Uppercase n is N. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.
    – Cindy Meister
    Nov 13 '18 at 13:25










  • I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
    – R. Coppens
    Nov 13 '18 at 14:09










2




2




Can be please post snippet of the code , you are using
– Arul Suju
Nov 13 '18 at 7:35




Can be please post snippet of the code , you are using
– Arul Suju
Nov 13 '18 at 7:35












FWIW in what you show the n is not "uppercase". Uppercase n is N. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.
– Cindy Meister
Nov 13 '18 at 13:25




FWIW in what you show the n is not "uppercase". Uppercase n is N. From what I can tell, this looks like a "superscript", although I wouldn't think Windows would respect superscript formatting, thus not affecting the file name. Is it possible this is a special Unicode value? You need to figure out exactly what this is / where it's coming from in order to be able to detect it.
– Cindy Meister
Nov 13 '18 at 13:25












I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
– R. Coppens
Nov 13 '18 at 14:09






I don't know if it is a special unicode value, I looked it up but wasn't able to find it. The code I'm using is to detect if the file is present in the location described in the pathway. But I defined the problem in retrieving the file name. This because a msgbox shows "Snkwrld.xlsx" instead of "Sⁿkwrld.xlsx". This filename is the only file name which gives an error, and is the only one with superscript. If not possible to fix I will change the bron code which names the files to get the superscript out of it.
– R. Coppens
Nov 13 '18 at 14:09














0






active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53275971%2fget-upercase-within-string-value%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.





Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


Please pay close attention to the following guidance:


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53275971%2fget-upercase-within-string-value%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Bressuire

Vorschmack

Quarantine