TO ASK A QUESTION: If you have a question or need help with Office, please feel free to use the 'Click to Contact' link at the bottom of this page. You'll get a form that you can use to email a question to me. (I had been getting a ton of spam when accepting direct emails, so only emails that use this form will get through to me.)

Please be sure to mention the version of Office you are using when you send your question.

I answer all e-mails that I receive via this form, as long as they are polite :)

Since disabling comments on this site, I'm actually hearing from more of you with questions ... so, as it seems people prefer to email rather than comment, I'm going to leave comments disabled. As always, you can ask me any Office-related questions you have. If the question is outside of my expertise, I'll try to direct you to where you can get an answer.

Hi, everyone! While I was away, people sent questions on a couple of different macro topics -- one Word and one PowerPoint. Thought the answers might come in handy for others - so I'll be posting them. For starters ... here's the PowerPoint question:

When you insert a slide into a presentation programmatically, PowerPoint doesn't advance your view automatically to the new slide. How do you do that?

Well, there's rarely just one answer to 'how do you do that' in VBA ... but here's how I do it:

Just create an integer variable and define it as being equal to the active view plus 1, like so:

Dim mySl As Integer
mySl=ActiveWindow.Selection.SlideRange.SlideIndex + 1

Then, after the line where you insert the new slide, use the GoToSlide method to get where you want to be:

ActiveWindow.View.GotoSlide Index:=mySl

The Word issue is quite interesting - so check back - I'll post that one as soon as I get a bit more information from the requestor about what she needs :)

Meanwhile, happy Thursday!