blopib Posted January 17, 2008 Report Share Posted January 17, 2008 We have experienced some trouble when copying from Excel to another application. When copying data from excel it eg. looks like this in the cell R27 DT71D4 in the excelsheet, but when it writes it out in the application it looks like this R27 Dt71D4 (a lowercase letter somewhere in the middle), it's can be randomly placed. I don't know what to think, I can't see that it should have something to do with timeing issues in ME, I don't know if it has something to do with ME at all or if it's something with the other application. Doesn't ME copy the ASCII code? If so it definitely should be a uppercase letter there. Someone who has a clue, why this is? Oh, have to run, time to go home Quote Link to comment Share on other sites More sharing options...
kevin Posted January 17, 2008 Report Share Posted January 17, 2008 Doesn't ME copy the ASCII code? If so it definitely should be a uppercase letter there. That all depends. Macro Express asks Windows for the content of the clipboard. It does not alter the information it receives in any way. I do not know specifically what is happening in this case but I have seen cases where an application stores information in mixed case and displays it in all upper case. I have also been surprised when some MS Office applications change what is placed on the clipboard to something you don't expect. However, the problems I have see relate to carriage returns and line feeds (newlines), not the case of a string. In short here is what happens: The application gives something to Windows to place on the clipboard. Macro Express asks Windows for the information on the clipboard. The macro uses the information as Macro Express received it. No changes are made. Quote Link to comment Share on other sites More sharing options...
blopib Posted January 18, 2008 Author Report Share Posted January 18, 2008 I have seen cases where an application stores information in mixed case and displays it in all upper case. I copy the data from Excel to a Oracle-based application and in some fields it's not allowed to write with lowcase letters, it automatically turns to uppercase letters. But in this field for designation it's ok to write both kinds. I'll put this in mind and try to figure out if it happens in some special situation, but I doubt that it's something that I can affect. Thanks Kevin for the answer anyway. Quote Link to comment Share on other sites More sharing options...
johnboy691 Posted January 18, 2008 Report Share Posted January 18, 2008 Just an idea to check. I've had this happen when pasting or typing to a green screen. In my particular case I discovered the person whose computer had the "problem" had changed the keyboard stroke for that key. Look into that. John Quote Link to comment Share on other sites More sharing options...
blopib Posted January 23, 2008 Author Report Share Posted January 23, 2008 I discovered the person whose computer had the "problem" had changed the keyboard stroke for that key Thanks for the tip, but in this case I don't think it has something to do with my problem, my macro copies the data from Excel and writes it to this other application, and the data is right in Excel but it turns out wrong in this other appl. and when it happens (it's seldom) it just happens randomly. Quote Link to comment Share on other sites More sharing options...
Cory Posted January 29, 2008 Report Share Posted January 29, 2008 Copy the text t your clipboard and paste it into a hex editor and see what the actual character codes are. Then copy to a text variable in ME and see if it changes. My guess is that the source system is all uppercase and will display both lower case and upper case characters as upper case. But when copied and pasted into another environment you may see they're actually different. I know MRP systems and various terminal based applications can have this problem. If you want them to always be upper case just convert the case on of the lower case characters in the macro. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.