find and replace text from word documents
-
basically i'm not using VB.NET but an Access application with VBA code in it. I posted in the vb.net forum as it's the nearest i can get to vba :P my problem is : i have a access database, and i want to export information into a MS Word file this is to be done from access, as a button, that gathers data and makes a word file from it. i have a working version, that uses a nicely written word file, with certain text named like "FIELD:01" etc.. and i have a button in my access application that (using vba) opens the word file (raw text) and does a string replace of the "FIELD:01" with the corresponding data. The problem arises when the text to be replaced it either other than English, or funny characters (like the degrees celcius symbol) Using mail merge features aren't good enough, because i want to insert 1 field of data, and not an entire table, and keeping formatting is important. I've been playing around with other file formats to replace into, (such as htm, xml, rtf ..) but i still haven't found a solution that is good for both special characters and greek. If this is posted in a terribly wrong place, please point me to the right direction. Thank you for any help, it will be much appreciated.
Ericos Georgiades
-
basically i'm not using VB.NET but an Access application with VBA code in it. I posted in the vb.net forum as it's the nearest i can get to vba :P my problem is : i have a access database, and i want to export information into a MS Word file this is to be done from access, as a button, that gathers data and makes a word file from it. i have a working version, that uses a nicely written word file, with certain text named like "FIELD:01" etc.. and i have a button in my access application that (using vba) opens the word file (raw text) and does a string replace of the "FIELD:01" with the corresponding data. The problem arises when the text to be replaced it either other than English, or funny characters (like the degrees celcius symbol) Using mail merge features aren't good enough, because i want to insert 1 field of data, and not an entire table, and keeping formatting is important. I've been playing around with other file formats to replace into, (such as htm, xml, rtf ..) but i still haven't found a solution that is good for both special characters and greek. If this is posted in a terribly wrong place, please point me to the right direction. Thank you for any help, it will be much appreciated.
Ericos Georgiades
i found a solution to my very own, confusing problem. an article that was written for office 97! http://support.microsoft.com/kb/131583[^] posted the solution in case someone else has similar problems :D
Ericos Georgiades