Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: VB Report Macro error
Topic Summary:
Created On: 21-Apr-2006 19:07
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 21-Apr-2006 19:07
User is offline View Users Profile Print this message


Kailash Gangar

Posts: 2
Joined: 9-Nov-2005

Anyone experienced/solved this...?

We have a customized macro (created by SA Consultants) which generates a Word report document.  The generated document would be in excess of 1000 pages.  However, we get a run-time error ("Visual Basic Run-time Error 4198: Command failed") at page 780.  Our report document has about 70 figures and alot of formatting.  I've searched the web for resolutions and have been unable to fix this error...

I'm thinking it might be that Word has a file-size limit that it can handle.

The macro has alot of repagination/save attempts.  I've noticed Word msgs. (bottom of page) to the effect of "The file size save time has been exceeded...".

Others have suggested to remove all of the Section Breaks and use Page Breaks instead.  While others have suggested to do the formatting at the end of document generation.

Any assistance would be appreciated?

KG

Report this to a Moderator Report this to a Moderator
 27-Apr-2006 15:46
User is offline View Users Profile Print this message


Andrea Heithoff

Posts: 33
Joined: 15-Aug-2005

When you're generating the document, maybe you could add a line to turn off pagination until the thing finishes writing data.  I've had similar problems with Excel macros and relcalculation.  I'm not sure it's even an option in the Word object library.

If you haven't already, you may want to see that the action when it hangs can be done through a standard Word export, or you may try to create separate documents with each major section or every X definitions/diagrams (a line or two inserted into the top of the for/next loop you're likely using).  1000 pages with heavy graphics and formatting is a pretty big file, so your suspicion is probably correct that there's a limit.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.