{"id":150,"date":"2013-04-01T12:07:42","date_gmt":"2013-04-01T17:07:42","guid":{"rendered":"http:\/\/homepages.uc.edu\/~yaozo\/wordpress\/?p=150"},"modified":"2013-04-01T12:07:42","modified_gmt":"2013-04-01T17:07:42","slug":"office-development-faq","status":"publish","type":"post","link":"https:\/\/zhuoyao.net\/index.php\/2013\/04\/01\/office-development-faq\/","title":{"rendered":"Office Development FAQ"},"content":{"rendered":"

\"\"\u00a0Access<\/span><\/b><\/p>\n

\u2022\u00a0How do I export data from Access to an XML file?<\/span><\/a>\u00a0(VBA, VB 6)<\/p>\n

\u2022\u00a0How do I print an Access Report?<\/span><\/a>\u00a0(VB 6)<\/p>\n

\u2022\u00a0How do I resize Access’ windows?<\/span><\/a><\/p>\n

\u2022\u00a0How do I bypass my database’s autoexec\/startup macro?<\/span><\/a><\/p>\n

\u2022\u00a0What are the types of Access Database Security?<\/span><\/a><\/p>\n

\u2022\u00a0How do I use Access’ built-in progressbar?<\/span><\/a><\/p>\n

\u2022\u00a0How do I perform a Compact & Repair on my database?<\/span><\/a>\u00a0(VB 6)<\/p>\n

\u2022\u00a0How do I transfer data between Access and Excel?<\/span><\/a>\u00a0(VBA, VB 6, VB.NET)<\/p>\n

\u2022\u00a0How do I send an email or email an Access Object?<\/span><\/a><\/p>\n

\u2022\u00a0How do I import\/copy a database object from another database?<\/span><\/a><\/p>\n

\u2022 Forms<\/p>\n

o\u00a0How do I show a form at the startup of Access?<\/span><\/a><\/p>\n

o\u00a0How do I add a SubForm to a Form?<\/span><\/a><\/div>\n

\u2022 Reports<\/p>\n

o\u00a0How do I color alternating rows on my report (Greenbar effect)?<\/span><\/a><\/p>\n

o\u00a0How do I add a SubReport to a Report?<\/span><\/a><\/div>\n<\/div>\n

\"\"\u00a0Excel<\/span><\/b><\/p>\n

\u2022\u00a0How do I open an existing Excel Workbook?<\/span><\/a>\u00a0(VB.NET)<\/p>\n

\u2022\u00a0How do I color individule parts of a cell\/range with separate colors?<\/span><\/a>\u00a0(VB.NET)<\/p>\n

\u2022\u00a0How to do Data Validation in MS Excel?<\/span><\/a><\/p>\n

\u2022\u00a0How to do Conditional Formatting in MS Excel<\/span><\/a><\/p>\n

\u2022\u00a0How to make your very first Pivot Table in MS Excel<\/span><\/a><\/p>\n

\u2022\u00a0How do I enumerate the sheets in a workbook without using Excel?<\/span><\/a>\u00a0(VB 6, VB.NET)<\/p>\n

\u2022\u00a0How do I create a new workbook?<\/span><\/a>\u00a0(VBA, VB 6, VB.NET)<\/p>\n

\u2022\u00a0How do I transfer data between Excel and Access?<\/span><\/a>\u00a0(VBA, VB 6)<\/p>\n

\u2022\u00a0How do I transfer data from SQL Server to Excel using ADO?<\/span><\/a>\u00a0(VB 6)<\/p>\n

\u2022\u00a0How do I transfer data between Excel and SQL Server using SQL Server DTS?<\/span><\/a><\/p>\n

\u2022\u00a0How do I email a workbook from within Excel?<\/span><\/a><\/p>\n

\u2022\u00a0How do I convert a csv file to an xls fileformat?<\/span><\/a>\u00a0(VB 6)<\/div>\n

\"\"\u00a0InfoPath<\/span><\/b><\/p>\n

\u2022\u00a0How do I show a custom template?<\/span><\/a>\u00a0(VB 6)<\/div>\n

\"\"\u00a0Outlook<\/span><\/b><\/p>\n

\u2022\u00a0How do I get the Senders email address from an email?\u00a0<\/span><\/a>(VB 6)<\/p>\n

\u2022\u00a0Where can I get the CDO Libraries (all versions) from?<\/span><\/a><\/p>\n

\u2022\u00a0How do I get the number of items in a folder?<\/span><\/a>\u00a0(VB.NET)<\/p>\n

\u2022\u00a0How do I make a HotKey (shortcut keypress) in Outlook?<\/span><\/a><\/p>\n

\u2022\u00a0How do I send an email using Outlook?<\/span><\/a>\u00a0(VB 6, VB.NET, C#)<\/p>\n

\u2022\u00a0Why do I get an Outlook Security Prompt?<\/span><\/a><\/p>\n

\u2022\u00a0How do I save\/remove an attachment from an email message?<\/span><\/a>\u00a0(VB 6, VB.NET, C#)<\/p>\n

\u2022\u00a0How do I programmatically read an Exchange Server’s Global Address List?<\/span><\/a>\u00a0(VB 6)<\/p>\n

\u2022\u00a0How do I Export ContactItems to a Access database?<\/span><\/a><\/p>\n

\u2022\u00a0How do I deploy or install Macros?<\/span><\/a><\/p>\n

\u2022 Outlook Forms<\/p>\n

o\u00a0How do I customize an Outlook Form?<\/span><\/a><\/p>\n

o\u00a0How do I show a UserForm from a Outlook Form’s button click event?<\/span><\/a><\/p>\n

o\u00a0How do I set the Default Form for a folder?<\/span><\/a><\/p>\n

o\u00a0How do I Publish my Form?<\/span><\/a><\/div>\n<\/div>\n

\"\"\u00a0PowerPoint<\/span><\/b><\/p>\n

\u2022\u00a0How to Create Charts & Graphs in Microsoft Powerpoint<\/span><\/a><\/div>\n

\"\"\u00a0Word<\/span><\/b><\/p>\n

\u2022\u00a0How do I read\/write to a document?<\/span><\/a>\u00a0(VB 6)<\/p>\n

\u2022\u00a0How do I print a document without opening it?<\/span><\/a>\u00a0(VB 6, VB.NET, C#)<\/p>\n

\u2022\u00a0How do I read\/write a document’s BuiltIn properties?<\/span><\/a><\/p>\n

\u2022\u00a0How do I create a Mailmerge?<\/span><\/a><\/p>\n

\u2022\u00a0How do I execute a Mailmerge?<\/span><\/a>\u00a0(VB6)<\/p>\n

\u2022\u00a0How do I add\/modify\/write a table programmatically?<\/span><\/a>\u00a0(VB 6)<\/p>\n

\u2022\u00a0How do I integrate Words spell checker into my program?<\/span><\/a>\u00a0(VB6, VB.NET)<\/p>\n

\u2022\u00a0How do I convert a Word Document to a Webpage?<\/span><\/a>\u00a0(VB.NET)<\/div>\n

\"\"\u00a0Visio<\/span><\/b><\/p>\n

\u2022\u00a0How do I add Shapes to a drawing?<\/span><\/a>\u00a0(VB 6)<\/p>\n

\u2022\u00a0How do I change the drawing layout and\/or page size?<\/span><\/a>\u00a0(VBA, VB 6, VB.NET)<\/p>\n

\u2022\u00a0How do I create or handle events in a drawing?<\/span><\/a>\u00a0(VBA, VB 6)<\/p>\n

\u2022\u00a0How do supress or automatically choose Alerts\/Prompts in a drawing?<\/span><\/a>\u00a0(VBA, VB 6, VB.NET, C#)<\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u00a0Access \u2022\u00a0How do I export data from Access to an XML file?\u00a0(VBA, VB 6) \u2022\u00a0How do I print an Access Report?\u00a0(VB 6) \u2022\u00a0How do I… <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[],"class_list":["post-150","post","type-post","status-publish","format-standard","hentry","category-vb-net"],"_links":{"self":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/comments?post=150"}],"version-history":[{"count":0,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/posts\/150\/revisions"}],"wp:attachment":[{"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/media?parent=150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/categories?post=150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhuoyao.net\/index.php\/wp-json\/wp\/v2\/tags?post=150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}