FAQ's: Office Development

[RobDog888]

Office Development FAQ

These are a few FAQ threads on the most used Office Suite Applications and general Office topics. If you have a common issue to add to the FAQ please PM me and I can add it. If you wish to add a reply to a topic, just post the reply as its moderated in the FAQ Forum. If you have questions or problems on a topic, post it in the OD forum.


Note: Code examples are in VBA format unless otherwise stated.


General

• Where did the VBA IDE go in Office 2007?

• How do I detect if an Office app is already running/created?

• How do I record a macro?

• About Macros, Security Prompt, and Digital Certificates...

• Can I get MS Office (any/all apps like Office Pro, One Note, Project, Visio, etc.) for Free?

• What the different major features between Office versions?

• How do I get the latest patches and service packs for Office?

• How do I programmatically determine the version of an Office App? (VB 6, VB.NET, C#)

• Where can I get basic tutorials & demos on the use any Office App?

Menus & Tool Bars

MS Office Menus & Toolbars are very simillar and are part of the same collection - Office.CommandBars.

• How do I add a custom menu item or toolbar button?

• How do I add a custom image to the menu item or toolbar button?

• How do I assign a standard Office image to a menu item or toolbar button?

UserForms

• How do I set a UserForm as the TopMost form throughout Windows (Added 10.19.2009)

• Creating an Event Handler Class

• UserForms Best Practices

• General Information About VBA UserForms

• How do I show my UserForm at the opening of my document or workbook?

• How do I disable the 'x' close button on a UserForm?

• How to transfer data between a UserForm and the Office Application?

• How do I show a context menu popup on a UserForm?

Continued in post #2...

Note: Images in this post are registered trademarks owned by Microsoft.

[RobDog888]

Office Development FAQ

Continued

Access

• How do I export data from Access to an XML file? (VBA, VB 6) (Added 07.12.2009)

• How do I print an Access Report? (VB 6)

• How do I resize Access' windows?

• How do I bypass my database's autoexec/startup macro?

• What are the types of Access Database Security?

• How do I use Access' built-in progressbar?

• How do I perform a Compact & Repair on my database? (VB 6)

• How do I transfer data between Access and Excel? (VBA, VB 6, VB.NET)

• How do I send an email or email an Access Object?

• How do I import/copy a database object from another database?

• Forms

o How do I show a form at the startup of Access?

o How do I add a SubForm to a Form?

• Reports

o How do I color alternating rows on my report (Greenbar effect)?

o How do I add a SubReport to a Report?

Excel

• How do I open an existing Excel Workbook? (VB.NET)

• How do I color individule parts of a cell/range with separate colors? (VB.NET)

• How to do Data Validation in MS Excel?

• How to do Conditional Formatting in MS Excel

• How to make your very first Pivot Table in MS Excel

• How do I enumerate the sheets in a workbook without using Excel? (VB 6, VB.NET)

• How do I create a new workbook? (VBA, VB 6, VB.NET)

• How do I transfer data between Excel and Access? (VBA, VB 6)

• How do I transfer data from SQL Server to Excel using ADO? (VB 6)

• How do I transfer data between Excel and SQL Server using SQL Server DTS?

• How do I email a workbook from within Excel?

• How do I convert a csv file to an xls fileformat? (VB 6)

InfoPath

• How do I show a custom template? (VB 6)

Outlook

• How do I get the Senders email address from an email? (VB 6) (Added 11.02.2009)

• Where can I get the CDO Libraries (all versions) from? (Added 10.26.2009)

• How do I get the number of items in a folder? (VB.NET)

• How do I make a HotKey (shortcut keypress) in Outlook?

• How do I send an email using Outlook? (VB 6, VB.NET, C#)

• Why do I get an Outlook Security Prompt?

• How do I save/remove an attachment from an email message? (VB 6, VB.NET, C#)

• How do I programmatically read an Exchange Server's Global Address List? (VB 6)

• How do I Export ContactItems to a Access database?

• How do I deploy or install Macros?

• Outlook Forms

o How do I customize an Outlook Form?

o How do I show a UserForm from a Outlook Form's button click event?

o How do I set the Default Form for a folder?

o How do I Publish my Form?

PowerPoint

• How to Create Charts & Graphs in Microsoft Powerpoint

Word

• How do I read/write to a document? (VB 6)

• How do I print a document without opening it? (VB 6, VB.NET, C#)

• How do I read/write a document's BuiltIn properties?

• How do I create a Mailmerge?

• How do I execute a Mailmerge? (VB6) (Added 07.08.2009)

• How do I add/modify/write a table programmatically? (VB 6)

• How do I integrate Words spell checker into my program? (VB6, VB.NET)

• How do I convert a Word Document to a Webpage? (VB.NET)

Visio

• How do I add Shapes to a drawing? (VB 6)

• How do I change the drawing layout and/or page size? (VBA, VB 6, VB.NET)

• How do I create or handle events in a drawing? (VBA, VB 6)

• How do supress or automatically choose Alerts/Prompts in a drawing? (VBA, VB 6, VB.NET, C#)

Continued in post #3...

Note: Images in this post are registered trademarks owned by Microsoft.

[RobDog888]

Office Development FAQ

Continued

Visual Basic 6.0

• How do I automate an Office App using VB 6?

• How do I use VB 6 to make an Add-In for an Office application?

• Si_the_geek's Excel Tutorial

.NET

• How do I automate an Office App using VB.NET?

• How do I automate an Office App using C#?

• How do I use .NET to make an Add-In for an Office application? (VB.NET, C#)

• Office Primary Interop Assemblies

• How do I convert VBA code to .NET?

• Office XP Automation Help File

Visual Studio Tools for Office

• VSTO 2003

o How do I make my first VSTO 2003 application? Almost Done!

Note: Images in this post are registered trademarks owned by Microsoft.