Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

Solved

display a change in document before VBA script ends

Posted on 2012-12-29

1 solution

Medium Priority

258 Views

Last Modified: 2012-12-29

I have the following code:

ActiveDocument.Bookmarks("Status").Range.Text = "Clearing All Unneeded Files - Please wait"
ClearAllUneededFiles

Open in new window

The bookmark change does not display until after the subroutine ClearAllUneededFiles completes. How do I display the bookmark change before running ClearAllUneededFiles?

TIA

Comment

Question by:thenelson

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

2 Comments

LVL 22

Accepted Solution

by:Flyster

Flyster earned 2000 total points

ID: 387300282012-12-29

You can add a timer event to delay the code:

Sub YourSub()
Dim Start, Lapse
ActiveDocument.Bookmarks("Status").Range.Text = "Clearing All Unneeded Files - Please wait"
    Lapse = 5 ' Set delay in seconds
    Start = Timer
    Do While Timer < Start + Lapse
        DoEvents
    Loop
ClearAllUneededFiles
End Sub

Open in new window

You can change the line Lapse=5 to however long you want the delay.
Flyster

LVL 39

Author Closing Comment

by:thenelson

ID: 387303212012-12-29

I kinda did the same thing you suggested only different:

ActiveDocument.Bookmarks("Status").Range.Text = "Clearing Unneeded Files - Please wait"
Application.OnTime Now + TimeValue("00:00:01"), "ClearAllUneededFiles"

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recommended hardware structure for Microsoft exchange server.

Article by: Abraham

New style of hardware planning for Microsoft Exchange server.

How Can Office 365 Help You With Your Marketing Campaign

Article by: Jen

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.

Building Probability Models in Excel Part 7: Modeling a Correlated Two-Fund Investment

Video by: Toby

The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

Creating a Launch Slide in PowerPoint

Video by: Thomas

The viewer will learn how to create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …