I need to write a standalone program or a function/macro built in excel or word to do some string replacement in a very wierd text file.
This file looks something like this....
HRBATL22DEC0500-0659$EV¥L<enter>HRBATL23DEC0500-0659$EV¥L....(unicode text characters). It is a series of dates and times that are used to pull numbers in an internal program at out company. These numbers have to be retreived for 7 days in advance every week.
The problem is, this internal program, cannot automate the date part of this entry. Hence a user has to find and replace the dates every time for every week. This file is in the format abcdef.KY1 (made for our internal program). It reads in notepad as the correct characters. Any changes made in notepad still preserve the proper format, but any changes in word or other software doesn't work.
I need someway in Excel or a standalone program / function / macro -> to read in this file wherever a string is given, and then replace it with a string and write back to it, without actually read/rewrit-ing any of the wierd unicode text characters (like the ¥ sign). If any of those characters are rewritten the file loses its program format.
I am not too good with file handling. If anybody can provide sample / guide code and guidelines to build from - I'd appreciate it.
This file looks something like this....
HRBATL22DEC0500-0659$EV¥L<enter>HRBATL23DEC0500-0659$EV¥L....(unicode text characters). It is a series of dates and times that are used to pull numbers in an internal program at out company. These numbers have to be retreived for 7 days in advance every week.
The problem is, this internal program, cannot automate the date part of this entry. Hence a user has to find and replace the dates every time for every week. This file is in the format abcdef.KY1 (made for our internal program). It reads in notepad as the correct characters. Any changes made in notepad still preserve the proper format, but any changes in word or other software doesn't work.
I need someway in Excel or a standalone program / function / macro -> to read in this file wherever a string is given, and then replace it with a string and write back to it, without actually read/rewrit-ing any of the wierd unicode text characters (like the ¥ sign). If any of those characters are rewritten the file loses its program format.
I am not too good with file handling. If anybody can provide sample / guide code and guidelines to build from - I'd appreciate it.