Solved

vb with word 2000

Posted on 2002-07-03
3
122 Views
Last Modified: 2010-05-02
Hey.

I'm exporting data from vb to word 2000 and the transfering time is very slow ,
I need to raise the transfering time.
(for example i try to export data from a matrix 50/15 that i defined in vb to a table in word ).
I'm using A word 9 object reference.

I have 256 Ram and cpu p3 500mhz so it cant be a performence problem.

Thank you for your help.
0
Comment
Question by:uzico
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 25 total points
Comment Utility
I guess that you are using Word Automation, so you should try this:

dim objWord as Word.Application 'i assume this...
<... your initialiation code here ...>
'stop word updating the screen all the time
objWord.Screenupdating= false
<... perform your data transfer ...>
objWord.Screenupdateing = true
<... your cleanup code...>

note that you should ensure that the Screenupdating=true is executed even if errors occur in the code, otherwise the user that wants to use word will run into small troubles :-)

Obviously, you won't be able to follow the process, thus you might implement a switch in the application that starts the process saying "Fast Processing" set by default, which runs the above. unset you only skip that property (probably for debugging purposes)

Cheers
0
 
LVL 49

Expert Comment

by:DanRollins
Comment Utility
Hi uzico,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Accept angelIII's comment(s) as an answer.

uzico, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.
==========
DanRollins -- EE database cleanup volunteer
0
 

Expert Comment

by:SpideyMod
Comment Utility
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now