[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel VBA Clear Word bookmark before adding new data

Posted on 2014-04-05
2
Medium Priority
?
497 Views
Last Modified: 2014-04-05
Hi

 How do I change the following code so that text previously inserted after a
bookmark is first cleared

 Set WordRange = WordDoc.GoTo(What:=wdGoToBookmark, Name:="School")
   WordRange.InsertAfter oSchool
0
Comment
Question by:Murray Brown
2 Comments
 
LVL 28

Accepted Solution

by:
MacroShadow earned 2000 total points
ID: 39980331
How much text, one word, two words, ten words, a sentence, a paragraph?

If you want the ability to delete dynamic text, you will have to store it in a variable.
0
 

Author Closing Comment

by:Murray Brown
ID: 39980405
Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

868 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