Microsoft Vba
9 Stories
10+ tips for working smarter with SQL
Techguide The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started.
Tags: Protocols and platforms, Column, Clause, Table, Value, Statement, Record, SQL, Goto, Microsoft VBA
Fill Word form fields with Access data
Techguide When you need to bring your Access data into a Word form, a little VBA can expedite the task. Susan Harkins walks through an example to demonstrate the process.
Tags: Microsoft Office, Table, Form, Record, Microsoft VBA, File Menu, Microsoft Excel, Microsoft Access, Microsoft Office, Microsoft Word
Hide the Ribbon programmatically in Access and Excel 2007
Techguide All of the Office 2007 applications sport the infamous Ribbon. Unfortunately for developers, the Ribbon object isn't as easy to control as its earlier counterpart, the command bar object.
Tags: Microsoft Office, Microsoft Corp., Mouse, Microsoft VBA, Microsoft Excel 2007, software, Microsoft Excel, Microsoft Word 2007, Microsoft Access, spreadsheet
10+ things that are broken in Access 2007
Techguide If you switch to Access 2007, you'll encounter more than just a radical new interface--some things are just plain broken. See what you can hotfix and what you'll have to live with.
Tags: Microsoft Office, Field, Slide, Microsoft Windows Vista, Tool, shortcut menu, Microsoft VBA, Microsoft PowerPoint, printer, toolbar
Use VBA to find hidden Excel sheets
Techguide If you have hidden sheets in Excel, it might be helpful to programmatically manipulate those sheets.
Tags: Microsoft Office, Document, File, Backup, File System, ASCII, Microsoft VBA, Microsoft Excel, Microsoft Windows, Microsoft Access
How to use the At and Ln indicators in Word's status bar
Techguide At and Ln are used in automating special format requirements. Here's what you need to know.
Tags: Microsoft Office, Form, Cell, Database, Microsoft VBA, File Menu, Microsoft Excel, Microsoft Access, window, spreadsheet
Nudge paragraphs in a Word document
Techguide Sometimes you need just a little more space before a paragraph. You have to update the style to reflect a little more space before or after each paragraph.
Tags: Microsoft Office, Formula, Microsoft Corp., user-defined function, Cell, Microsoft VBA, Ingersoll-Rand, performance, keyboard, Microsoft Excel
Use an Excel command to quickly separate first and last names
Techguide If you need to split a list of names into two columns, you don't have to do it manually. See how this Excel wizard can quickly knock out the task for you.
Tags: Microsoft Office, Microsoft Corp., Column, Dirty Property, check box, Microsoft VBA, Microsoft Excel 2007, Figure F, Microsoft Excel, Microsoft Word 2007
Two ways to return a unique list in Excel
Techguide Filtering data to produce a unique list of entries is a common task in Excel. Here are two methods of getting the job done: manually and with a bit of VBA automation.
Tags: Microsoft Office, Microsoft Corp., Data, List, Cell, Database, AdvancedFilter Method, Default Value, Mouse, Microsoft VBA
