HELP with Interface

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

klav - 06 Jul 2005 21:12 GMT

We have a custom web-based application which passes data to Word and executes
a macro which does a lot of formatting and then displays the document in
print preview to the user.

I don't want the user to see the file until all the formatting is done and
the file is ready to be print previewed. I cannot seem to achieve this....no
matter what code I use (making Word invisible, the window invisible, the
window small, etc.) the file is briefly shown before all of the formatting
begins to take place and it makes for a very sloppy interface. Plus, I ran
into problems with making things invisible -- was getting sporadic errors and
problems so I removed that.

I would even be OK with displaying a form first telling the user the file is
being processed but I cannot get that to work smoothly either -- the darn
file is always visible.

Need help with this.....please answer quickly.....thanks.

Reply to this Message

Pat Garard - 06 Jul 2005 22:13 GMT

G'Day Klav,

Have you tried:-

Sub DoSomething()
Application.ScreenUpdating = False
:
'Something happens here, but changes are not displayed
:
Application.ScreenUpdating = True
End Sub

Word remains visible, but no Screen Updating occurs.
You must also arrange to set ScreenUpdating to True
in the event of the Macro halting due to an Error (i.e. in
your Error Trap).

Signature

Regards,
Pat Garard
Melbourne, Australia
_______________________

> We have a custom web-based application which passes data to Word and
> executes
[quoted text clipped - 23 lines]
>
> Need help with this.....please answer quickly.....thanks.

Reply to this Message

klav - 07 Jul 2005 12:35 GMT

Thanks for the quick response. The data that is being passed to Word from
the web application is visible in a document as soon as Word starts -- in
other words, my macro is not opening the file, it's already opened and
displayed in "document1." The screenupdating command doesn't take effect
soon enough -- you still see the data.

> G'Day Klav,
>
[quoted text clipped - 39 lines]
> >
> > Need help with this.....please answer quickly.....thanks.

Reply to this Message

Pat Garard - 07 Jul 2005 22:20 GMT

G'Day Klav,

I cannont 'see' your application, so it is not clear to me where
the Macro is called from.

If 'YOU' are starting Word (ie your Macro), then Start Word with
a startup switch such as :
(from help)
'/tTemplateName'
Start Word with a new document based on a template other than the
Normal template. Example: /tMyfax.dot
Note If the file name has spaces in it, enclose the complete name
in quotation marks - for example, /t"Elegant Report.dot"
(Put the code to suppress ScreenUpdating in the Document_New()
Procedure of the Template.)
OR
/mMacroName
Start Word and then run a specific macro. The /m switch also
prevents Word from running any AutoExec macros.
Example: /mSaleLead
(Put the code to suppress ScreenUpdating in the MacroName Proc
of the Normal Template.)
OR
combine these.

Signature

Regards,
Pat Garard
Melbourne, Australia
_______________________

> Thanks for the quick response. The data that is being passed to
> Word from
[quoted text clipped - 54 lines]
>> >
>> > Need help with this.....please answer quickly.....thanks.

Reply to this Message