Previous Page...
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!
Dymo LabelWriter Part II
Abstract from Daily Dose of Excel (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 [...]
Using Outlook 2010 with or without Word 2010 installed
Abstract from Slipstick Systems (Indexed 2010-08-31):
Although the Word-based e-mail editor built into Outlook 2010 does not require that Word 2010 be installed, additional features and commands are available when you install Word 2010 with Outlook 2010. This article compares the features and commands available with or without Word 2010 installed.
Determine when to install Outlook 2010
Abstract from Slipstick Systems (Indexed 2010-08-31):
You can install Outlook 2010 before, during, or after an installation of other applications in Office 2010. You can also deploy Outlook 2010 to different groups of users at different times. Note that installing Outlook 2010 without Microsoft Word 2010 limits Outlook 2010 functionality in the following ways: 1) The Outlook 2010 e-mail editor has fewer features, and 2) Internet Fax functionality is not available. This article describes the requirements, advantages, and disadvantages of each instal...(truncated)...
Roman Numerals for Page Numbers
Abstract from Allen Wyatt's Excel Tips (Indexed 2010-08-30):
Add page numbers to a worksheet, and they print out as Arabic numerals. If you want to use Roman numerals instead, youll want to use the techniques described in this tip.Read this ExcelTip: Roman Numerals for Page NumbersMicrosoft Excel Tips - Learn Excel Faster!