a naive question 
Author Message
 a naive question

I inherited the maintenance of a batch VBA application for word for
manipulation of tables and "cleaning" to desired format.  this app is
intended to run on batch of documents overnight, with  word 2000  in windows
2000.

Now the client has migrated to Xp pro and Word 2002. The vba app is having a
lot trouble in that it does not seem to handle errors and stop processing
Furthermore, when it runs into error, it hogs the CPU ( 99%)..  It also
every now and then cause prompts to merge with such and such.dot (templates)
which is not supposed to.

I was wondering if it would be better to migrate to vbs script or .net
Visual Basic or C# while I adapt the vba to handle exceptions... right now
the vba app is about 7 pages long in code plus a couple of forms.



Mon, 05 Dec 2005 12:43:29 GMT  
 a naive question
There are almost too many ways to answer your question. The first issue is
what language will be easiest for you to use. The second lies in
understanding where your program is either too complex or too slow.
Any of the tools you meantion will do the job. Compiled code will almost
always run faster than script--but you can also use combinations of script
and compiled code too. If you're looking to get a jump on things then C# is
a good choice since it seems to be the favored language for .Net development
but if you're familiar with VB then VB.Net might be an easier transition and
their is virtaully no difference in performance between VB.Net and C#. So
like they say at Microsoft "Where do you want to go today?"


Quote:
> I inherited the maintenance of a batch vba application for word for
> manipulation of tables and "cleaning" to desired format.  this app is
> intended to run on batch of documents overnight, with  word 2000  in
windows
> 2000.

> Now the client has migrated to Xp pro and Word 2002. The vba app is having
a
> lot trouble in that it does not seem to handle errors and stop processing
> Furthermore, when it runs into error, it hogs the CPU ( 99%)..  It also
> every now and then cause prompts to merge with such and such.dot
(templates)
> which is not supposed to.

> I was wondering if it would be better to migrate to vbs script or .net
> visual basic or c# while I adapt the vba to handle exceptions... right now
> the vba app is about 7 pages long in code plus a couple of forms.



Sat, 10 Dec 2005 12:27:17 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. naive questions: GhostScript, StyleScript, fonts?

2. a naive question on clipboard

3. naive question about PostScript

4. very naive question

5. possibly another naive question

6. a naive question?

7. naive question re decompile

8. Naive questions with creating a com+ component?

9. Naive question from an outdated Techy - GDI heap status in VB6

10. naive question?: how can one open another intenet explorer application from a script within hta?

11. FindFirst, FindNext, Seek - naive(?) question

12. Naive ComboBox Question

 

 
Powered by phpBB® Forum Software