Search:

Not sure this will work, but you could try:

pptApp.CommandBars.ExecuteMso ("PasteAsEmbedded")

Gary

Welcome to the Lounge!

It looks like there's no really good way to present different sized checkboxes in a Word drop-down list.

For one thing, you can't assign different font size values, to...

You don't mention which version of Word you're using, but if you're using Word 2007 or later, the menus have been replaced by the Ribbon. Can't check Word 2007 at the moment, but for Word 2010, go...

How lengthy are the text entries that get entered? If they're not too long, then creating this as a protected Excel form is certainly also an option. You can produce the equivalent of a Word forms...

Just want to note that I agree with Paul and Andrew's suggestions, that having three checkboxes is not the best way to go.

Gary

Jun,

Welcome to the Lounge!

This can be done, but it will take a little work to set up:
First, double-click on each 'Yes' checkbox, and set the Bookmark name as follows: "chkY1", "chkY2",...

I believe the designated location for user templates (where Normal.dotm is typically stored), is by default a trusted location, so the user shouldn't be getting a macro prompt in the first place. In...

Glad that worked. (Sorry for delay in responding - going through a busy stretch!)

No, I'm saying that since you're declaring a variable for a Word document, give it a variable name that...

Avraham,

Does:

objWord.Close

not work in this case?

(By the way your choice of a variable name is a little confusing - normally objWord would be used to refer to a Word application...

Jim,

As a starting point, check the document's attached template. You can see the document's attached templatename and path by clicking on the Document Template button in the Developer tab. If...

Here's some code to do that:

Public Sub FindTextAndAddCR()
Selection.HomeKey Unit:=wdStory
With Selection.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text =...

Dave,

Still helpful to know what the recorded macro part is doing - are you doing a Find/Replace?

Gary

Rory, thanks for this info too - adding a Totals Row definitely works here.

Gary

That's much simpler - thanks Steve!

Gary

There's more than one way to loop through the entire document content, but the best method would depend on what you're needing to accomplish with the "[recorded macro]" part - so: what's the overall...

Is there any relatively simple way to do the following?
The first picture shows an example Excel (2010) table with no filtering applied. The ‘Cost’ column is summed at the bottom with a simple SUM...

One way to do this: Put the header and footer content into tables.

For instance, if in the footer you have some content that needs to align to the left margin, and other content that needs to...

Charlotte,

Just getting back to initial questions since nothing is working so far:

1) What type of template is it? - That is, is this a 'document' template that you use for creating new...

Here's a simple version of code that will loop through every paragraph in the document, and reapply whatever style is applied, to each paragraph. It's been awhile since I've done this type of...

Glad we've been able to assist.

Regarding the header, you should pretty much be able to apply any kind of formatting that's available for use in the main body of the document, in the header at...

Just want to add another tip, to help make your page more manageable when you get rid of the textbox: First, take all of the graphics that you currently have 'floating' at the top of the page, and...

The text being in a textbox is a clue to why you can't get the text to wrap around your picture. If you get rid of the textbox, and just put the text in the regular, default "text layer" of the...

Russ,

Are there any Office policy settings in effect?
Do you have any global templates running, either your own or third-party?

Gary

Paul,

Just a note that you may be able to post the .odt file here if you put it a .zip container first.

Gary

Not really a direct solution, but can you put the post-endnote content into a separate document?

If you were for example, publishing the completed book to a PDF, you could combine the two Word...