Aggregated Posts (sorted by date)
Excel DNA Hello World Function
Abstract from Methods In Excel (Indexed 2010-09-03):
OK, enough with the back story, lets get down to business. In this post we are going to look at the simplest way to use Excel DNA. This methods is ideal if you want to write User Defined Functions (UDF), or want to copy a UDF from VBA to DNA for a quick and easy* [...]
Setting a Base Directory
Abstract from Dick Kusleika (Indexed 2010-09-02):
If you want your Excel app to default to a specific directory when opening or saving files, see Changing the Current Directory. Be sure to read the comments.I have a slightly different situation. I want my app to open to a specific directory that will give me easy access to sub directories. [...]
Tip Word: AutoCorrect Dialog Shortcut
Abstract from Maarten van Stam (Indexed 2010-09-02):
[Image] Many things have changed over time. This is also the case for Office applications such as Word, Excel, Outlook and what else is there (The Office System as we know it today is a huge suite of applications and the number of applications available is depending on the SKU home, professional, business).One of the things changed is that the toolbars and menus have changed into the Fluent UI also known as The Ribbon. Some applications (Word, Excel) moved to The Ribbon with version 2007, other...(truncated)...
Non-printing Page Borders
Abstract from Allen Wyatt's Word Tips (Indexed 2010-09-02):
With your page border in place, you might be surprised if you dont see one side of the border (or all sides) print out with your document. Heres the reason for the missing border sides and what you can do about it.Read this WordTip: Non-printing Page BordersMicrosoft Word Tips - Learn Word Faster!
Setting a Base Directory
Abstract from Daily Dose of Excel (Indexed 2010-09-02):
If you want your Excel app to default to a specific directory when opening or saving files, see Changing the Current Directory. Be sure to read the comments.I have a slightly different situation. I want my app to open to a specific directory that will give me easy access to sub directories. [...]
OWA for PDA
Abstract from Slipstick Systems (Indexed 2010-09-02):
Access your Exchange Inbox, Calendar, Contacts, Tasks, and your organization's Public Folders simply by using the browser on any portable device.
ShareContacts for Outlook
Abstract from Slipstick Systems (Indexed 2010-09-02):
Sync Outlook contacts on multiple PCs without Exchange server. Microsoft Outlook add-in for synchronizing and sharing Outlook contacts. Sync contacts folders, sync address book, sync distribution lists in a few clicks. Synchronize and share Outlook contacts automatically. Share different contacts folders with various groups of people, subscribe to contact folders updates. Support custom Outlook contact forms. Sync between all Outlook versions. Version 3.41.
ShareCalendar for Outlook
Abstract from Slipstick Systems (Indexed 2010-09-02):
Sync Outlook calendar on multiple PCs without Exchange server. Microsoft Outlook add-in for sharing and synchronizing Outlook calendar items. Sync calendar folders, sync appointments, sync meetings in a few clicks. Synchronize and share Outlook calendar automatically. Share different calendar folders with various groups of people, subscribe to calendar updates. Share your Free Busy time. Create group calendar. Sync between all Outlook versions. Version 3.41.
Count Active Customers
Abstract from Dick Kusleika (Indexed 2010-09-01):
Jake wants to know, given an active date and an inactive date, how to count the customers that were active in a certain time period.The ones we want are highlighted in yellow. The formula is=COUNT(D2:D21)-SUMPRODUCT(($C$2:$C$21>=D25)+($D$2:$D$21< =C25))It’s easier to figure out who is not active during that date range and subtract it from the total. [...]
Follow-up paper from FMS, Inc. on a popular topic: SQL Azure and Access
Abstract from Erik Rucker (Indexed 2010-09-01):
Two recent papers written by Luke Chung of FMS, Inc. about SQL Azure and Access have created a lot of interest on his blog, as well as a few linked forum discussions. In response, Luke has written a follow-up paper about deploying an Access database once its linked to SQL Azure. He has also revised his original paper about linking to SQL Azure to clarify that you only need to install the SQL Server 2008 R2 Management Services program (SSMS) and not SQL Server itself. Thanks again, Luke! Luke ...(truncated)...
Add-in that lists the IDs (idMSOs) of context menu controls is now available
Abstract from Frice (Indexed 2010-09-01):
As part of Office 2010 extensibility, it is now possible to extend Context Menus exists, e.g. adding new buttons to a particular context menu in Word/Excel/etc.. To extend a particular Context Menu developers need to know the id name of that particular Context Menu; for that purpose UEX publishes every release a list with all the names of all the extensible controls in Office. However, is not easy for developers to look at the huge list and find the context menu he/she wants to extend because so...(truncated)...
Count Active Customers
Abstract from Daily Dose of Excel (Indexed 2010-09-01):
Jake wants to know, given an active date and an inactive date, how to count the customers that were active in a certain time period.The ones we want are highlighted in yellow. The formula is=COUNT(D2:D21)-SUMPRODUCT(($C$2:$C$21>=D25)+($D$2:$D$21< =C25))It’s easier to figure out who is not active during that date range and subtract it from the total. [...]
Just released: ASAP Utilities 4.6.1
Abstract from asap utilities / excel blog (Indexed 2010-09-01):
The new version of ASAP Utilities, 4.6.1 has just been released!A few nice additions have been added and a few bugs were fixed.We also fixed the startup error that sometimes occurred due to a bug in Excel 2010.Download ASAP Utilities 4.6.1View the changes.Manythanks to everyone who has contributed their feedback and tested the pre-release!PS.For the [...]
Personal HelpDesk for Outlook
Abstract from Slipstick Systems (Indexed 2010-09-01):
An automated ticketing system for one-person helpdesk and issue tracking in Microsoft Outlook. Log, analyze, track and escalate support requests in an organized and structured process in Outlook. Auto-process incoming support requests and send automated notification emails or SMS alerts. Supports enforcement of SLA in line with ITIL guidelines. Integrated knowledge base, asset tracking and statistical tools. Support for Skype and Phone calls. Includes a self-service website where end-users can s...(truncated)...
DesktopMirror for Outlook and Palm Desktop
Abstract from Slipstick Systems (Indexed 2010-09-01):
DesktopMirror for Outlook and Palm Desktop lets you synchronize information between Palm Desktop and Microsoft Outlook. It is also a handy tool that lets you move your Palm or Treo information to other mobile phones such as iPhone, Android or BlackBerry.
SysTools Outlook Recovery
Abstract from Slipstick Systems (Indexed 2010-09-01):
Raw pst file reader tool to read corrupt ms outlook .pst files. Performs complete scan of pst file and restores emails, contacts, calendars, tasks, journals etc. from the damaged ms outlook file.
=VLOOKUP (uhhnow what?)
Abstract from David Gainer (Indexed 2010-08-31):
[Image] Today’s post is brought to you by Anneliese Wirth, a writer on Office.com.On Office.com, the term “VLOOKUP” frequently bubbles up in our list of high-volume search queries. My job is to figure out why this is and what specific information people are actually looking for when they type “VLOOKUP” into the search box in Help or on our web site. The “VLOOKUP” query appears to represent a bunch of different questions. Certainly, one of the main ones ...(truncated)...
Dymo LabelWriter Part II
Abstract from Dick Kusleika (Indexed 2010-08-31):
A couple of weeks ago, I posted some code to print labels on a Dymo LabelWriter 450. I wanted to post the finished code because it has a few more tricks in it.Function PrintBoardFileLabel(ws As Worksheet) As Boolean Dim bReturn As Boolean Dim vaPrinters As Variant Dim i As Long [...]
Protecting Worksheets from Deletion
Abstract from Allen Wyatt's Excel Tips (Indexed 2010-08-31):
If you share a workbook with others in your office, you will probably want to make sure that some of the worksheets dont get deleted. Here are some ideas on how to get the protection you need.Read this ExcelTip: Protecting Worksheets from DeletionMicrosoft Excel Tips - Learn Excel Faster!
Options in Opening Files
Abstract from Allen Wyatt's Word Tips (Indexed 2010-08-31):
Changing the standard shortcut for opening a New File.Read this WordTip: Options in Opening FilesMicrosoft Word Tips - Learn Word Faster!