Solved What is the correct way to linearly insert text into Word?

Powerpoint automation is equally flakey.

Long routines that run fine 95% of the time will error out, normally with an "Object not defined" or when trying to activate chart data worksheets "Object not available" or some other similarly vague message.

Even more frustratingly, if you click continue, it carries on running completes the action it said it couldn't and works until the next random error. Go figure.

It also slows down significantly if you have had things open for a while. One routine that updates 8 different sets of slides, if you reboot before setting it off takes approx 4 minutes per set. The last time I ran it this week (forgetting to reboot), it took 1 hour 20 minutes. 🤦‍♂️
 
I did manage to create a Word document from COBOL by using the .rtf format.
since the days of FoxPro DOS, I have been doing the bulk of reports in HTML format (in the main 20-40 tags) from all ACCESS, EXCEL,....
- code visibility
- convenient to view in the browser
- opens for revision in EXCEL if necessary
- convenient to print in WORD - provides automatic selection of column widths and row heights
 

Users who are viewing this thread

Back
Top Bottom