In your solution, you have to rely on the existance of a macro and the filenames always have to be the same. Maybe with some COM scripting, you could create a more flexible and reusable script.
I would, Witto, the only problem is that I can't :).
I'm newbie in Kix, and my knowledge stops here. I only found what suits me at the moment - fast conversion of a text file from UTF-8 to ANSI (cp:1251) in my case. I needed fast resolution and fully automated.
I know it's rubbish as a composite, but that's why I posted it - if someone more experienced can transform it into a more neat solution.
My guess is CreatObject ("Word.Application")
Open document... SaveAs....
And I stop here, I don't know how to set the Encoding to what I desire.
Maybe a UDF will be perfect to create, but I don't know if it will be useful for many people, and yes - you must have MS Word installed - another dependency.
