J
jjfeenix
Very Weird problem. I have a Word doc with lots of VB programming behind it.
The initial purpose is to capture data input into a form and save it in Word
Tables (containing approx. 100 rows of records) as DOC files. After the
week's data is input and checked, every Wed. we run macros containing code
that creates TXT files from all the Word DOCs, concatenates all the TXT files
into one large TXT file, creates an RTF file containing some reporting on the
whole process and then opens the lager TXT in XL for further manipulation.
This doc and the programming behind it, has been in weekly service for
greater than a year with absolutely NO PROBLEMS. It was developed and is
being used in Word 2001 and 2003.
PLEASE NOTE--I didn't write this code, so I'm at a big loss in knowing
exactly what I'm looking at/for.
Anyway, between the last time we ran the concatenation and reporting
functions (on Wed. 10/21) and this Wed. (10/28) something has broken. The
code that create userforms, accept data entry, populate the tables and
produce the separate and concatenated TXT files are working fine. But when it
comes to the writing of report data in a created RTF file it just stops with
no error (maybe that's been turned off???) and it never gets to calling XL to
do it's part.
Thinking our master files got corrupted, we went back to files that worked
last Wed. and they no longer work. Thinking it was a problem with one PC, we
tried every one in the office--same problem. Then we went off site to 2 other
machines and they have the same problem. How can this be? It makes no sense.
We are running this under Windows 2000 Pro and XP (no Vista or Windows7
machines to try it on.) Could there have been a Windows or Word update that
broke VB in a week's period of time?
TIA for your thoughts and suggestions.
JohnS
The initial purpose is to capture data input into a form and save it in Word
Tables (containing approx. 100 rows of records) as DOC files. After the
week's data is input and checked, every Wed. we run macros containing code
that creates TXT files from all the Word DOCs, concatenates all the TXT files
into one large TXT file, creates an RTF file containing some reporting on the
whole process and then opens the lager TXT in XL for further manipulation.
This doc and the programming behind it, has been in weekly service for
greater than a year with absolutely NO PROBLEMS. It was developed and is
being used in Word 2001 and 2003.
PLEASE NOTE--I didn't write this code, so I'm at a big loss in knowing
exactly what I'm looking at/for.
Anyway, between the last time we ran the concatenation and reporting
functions (on Wed. 10/21) and this Wed. (10/28) something has broken. The
code that create userforms, accept data entry, populate the tables and
produce the separate and concatenated TXT files are working fine. But when it
comes to the writing of report data in a created RTF file it just stops with
no error (maybe that's been turned off???) and it never gets to calling XL to
do it's part.
Thinking our master files got corrupted, we went back to files that worked
last Wed. and they no longer work. Thinking it was a problem with one PC, we
tried every one in the office--same problem. Then we went off site to 2 other
machines and they have the same problem. How can this be? It makes no sense.
We are running this under Windows 2000 Pro and XP (no Vista or Windows7
machines to try it on.) Could there have been a Windows or Word update that
broke VB in a week's period of time?
TIA for your thoughts and suggestions.
JohnS