VB.Net

Office Development FAQ

calsalmon April 1, 2013

Access

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

• 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)

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

• 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)

• 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#)