Excel and Acrobat and accented characters

Scripting Forums AppleScript | Mac OS X
#1

I’m having trouble getting international characters (accents) to come across.

I am working on a script that pulls data from cells in an Excel spreadsheet and puts the data in the document summary fields (Title, Subject, Author, Keywords) of an Acrobat file. It works except that accented characters don’t come across in the pdf file. In this case the test files are in Portuguese. To be honest it’s a wonder to me that I have got this far with it working. :shock: Is there something I need to do in the scripting language to work with international characters?

I am building the script while working in OS X and running the OS X version of Excel and with Acrobat 5 in Classic.

#2

If you create a blank pdf and put all of the accented letters you need in the title in the document summary, save and then open the resultant pdf in textedit or somesuch so that you get the raw pdf code. You can use the character equivalents that you find and then use a simple search and replace in applescript.

I got, for example (I use text-equivalents here, rather than the actual symbols, just so you know) a-acute becomes E-agrave, when Acrobat has processed the a-acute I entered.

If you have the code you used here and wouldn’t mind sharing it, I would like a copy.

Regards,

P.