alfranco17
Board Regular
- Joined
- Apr 14, 2013
- Messages
- 198
Hi.
I have a macro enabled workbook in a shared folder. It is used by three people. One has Excel in English, the other two have Excel in Spanish.
To use Special Paste - Text in Spanish, the format is "Texto", in English, it is "Unicode Text".
I decided to try to do it both ways with an "On Error Resume Next" and expect one of them to fail.
Is there a more elegant solution? Like using a number instead of a string for format?
Thanks.
Armando.
I have a macro enabled workbook in a shared folder. It is used by three people. One has Excel in English, the other two have Excel in Spanish.
To use Special Paste - Text in Spanish, the format is "Texto", in English, it is "Unicode Text".
I decided to try to do it both ways with an "On Error Resume Next" and expect one of them to fail.
VBA Code:
On Error Resume Next
ActiveSheet.PasteSpecial Format:="Texto"
ActiveSheet.PasteSpecial Format:="Unicode Text"
On Error GoTo 0
Is there a more elegant solution? Like using a number instead of a string for format?
Thanks.
Armando.