Word 2011 Editing Tables Code Alters A

This code alters a parameter query: Sub AlterParameterQuery() ActiveSheet.ListObjects(TableName).ConvertToRange Set qt Sheets(sheet1).QueryTables(1) qt.Sql SELECT FROM authors WHERE (city) Set param1 qt.Parameters.Add(City Parameter, xlParamTypeVarChar) param1.SetParam xlConstant, Oakland qt.Refresh End Sub The first time you add a query to a worksheet, its name is Table1.

You can make a parameter query in VBA by using a question mark.

Word 2011 gives you shortcuts to position an object in your document.

A word-processing document flows that way so that your objects stay in the same relative position to the text as you add or delete text and objects.

Think of this as dropping a boat anchor water flows by, but the boat stays in the same position relative to the shore.

In Word, if you anchor an object to a margin, the object stays in the same relative position.

Word 2011 Editing Tables Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

Word 2011 For Mac Editing Tables