Aggregated Posts (sorted by date)
Looking for more SharePoint 2010 Info? Check out these Free Webcasts by Critical Path Training
Abstract from Andrew Connell (Indexed 2010-03-10):
We at Critical Path Training announced a handful of free one-hour webcasts over the next three months devoted to SharePoint 2010. All webcasts are delivered by our premier SharePoint professionals such as David Mann, Asif Rehmani, Scot Hillier, Wouter van Vugt, Ted Pattison and myself. Topics include: PowerShell Boot Camp for SharePoint Professionals Exploring the New Service Application Framework in SharePoint 2010 Introduction to SharePoint Designer 2010: Top 5 Great Things to Know! ShareP...(truncated)...
Showing Filter Criteria on a Printout
Abstract from Allen Wyatt's Excel Tips (Indexed 2010-03-10):
When you print out a filtered worksheet, you may want some sort of printed record as to what filtering was applied to the worksheet. Heres a couple of ways you can get that printed record.Read this ExcelTip: Showing Filter Criteria on a PrintoutMicrosoft Excel Tips - Learn Excel Faster!
Automatically Updating Fields and Links
Abstract from Allen Wyatt's Word Tips (Indexed 2010-03-10):
You can update fields and links automatically when you print your document, but what if you want them updated when you open or close the document? That is not as easy of a proposition, but there are ways to fulfill the request, as shown in this tip.Read this WordTip: Automatically Updating Fields and LinksMicrosoft Word Tips - Learn Word Faster!
SharePoint by Day, SharePint by Night – SharePoint 2010 Pro Summit Edition
Abstract from Andrew Connell (Indexed 2010-03-09):
[Image] Going to the SharePoint 2010 Pro Summit Conference in Las Vegas the week of March 16-19, 2009? No? Well, are you a SharePoint person thats going to be in the greater Vegas area? Well be doing another SharePoint by Day, SharePint by Night in Las Vegas the night before the big show starts (or in the case if youre one of the pre-conference session attendees, unwind): Tuesday, March 16, 2009 from 7p whenever. Come join other SharePoint professionals for a good drink and banter at the Carme...(truncated)...
Cool Forms! Team Signoff Form
Abstract from InfoPath Team Blog (Indexed 2010-03-09):
This weeks cool InfoPath form is a simple form that were using for each team in Office to sign off that Office 2010 is ready to ship. One of the neat things about this form is that it makes the signoff process a visual experience by using conditional formatting to show and hide pictures based on the status. [Image] The form also contains rules to enforce that final signoff can only happen once both bug and testing signoffs have been completed.[Image] If you have a cool form that you would l...(truncated)...
Tricks with app.config and ClickOnce deployment (Saurabh Bhatia)
Abstract from Paul Cornell (Indexed 2010-03-09):
Storing settings in the config File The app.config file is used for many purposes and one of common uses is for storing application settings like connection strings. For example, you can store a string to the web service reference used by your application in the app.config file.The idea behind storing the string in the app.config is that you could simply replace the file and change the value of the string. Thus, if you change the web service URL, you could simply replace the app.config and pick ...(truncated)...
Read this, its (about) the Law
Abstract from Methods In Excel (Indexed 2010-03-09):
A while back JW notice that some clever chap had been ripping content from his, and other peoples Excel blogs, and reposting it, un attributed. A bit more dig from part time PI Deb Dalgleish unearthed a few sites, all belonging to the same chap, with yet more content theft. Some of the stuff was [...]
SharePoint 2010 and Office 2010 RTM in April 2010, released March 12, 2010
Abstract from Andrew Connell (Indexed 2010-03-08):
Arpan Shah of Microsoft announced last Friday that they SharePoint 2010 and Office 2010 will RTM next month, in April 2010. This marks a big milestone after a year of SharePoint and Office being in beta and available to many internal testers under the TAP program and a public beta late last year, were now on the cusp of a public release of the final version. After working with SharePoint 2010 for over 1.5 yrs Im looking forward to the final version and being able to teach SharePoint 2010 on th...(truncated)...
SharePoint 2010 and Office 2010 RTM in April 2010, released May 12, 2010
Abstract from Andrew Connell (Indexed 2010-03-08):
Arpan Shah of Microsoft announced last Friday that they SharePoint 2010 and Office 2010 will RTM next month, in April 2010 & the official launch date ison May 12, 2010.This marks a big milestone after a year of SharePoint and Office being in beta and available to many internal testers under the TAP program and a public beta late last year, were now on the cusp of a public release of the final version. After working with SharePoint 2010 for over 1.5 yrs Im looking forward to the final version and...(truncated)...
Getting Array Data from a Filtered List in VBA
Abstract from Dick Kusleika (Indexed 2010-03-08):
Getting data from an Excel sheet into an array is usually best accomplished with a statement that looks something like this:vMyArray = Sheet1.UsedRange.ValueI thought it would be keen to fill an array from a filtered list, so I codedSub ArrFilteredList() Dim vArr As Variant vArr = Sheet1.UsedRange.SpecialCells(xlCellTypeVisible).Value [...]
The Access Show: How the Microsoft Legal Department uses Access 2010 web databases
Abstract from Erik Rucker (Indexed 2010-03-08):
Meet Malori! Malori is a paralegal in Microsoft's legal department. She manages patent applications and assigns them out to attorneys and portfolio managers as well as other paralegals. Malori was looking for a way to make her team more efficient by presenting all of the information they needed in a single web page or application. Our team jumped in and made an Access Services solution, which allows her to manage all the data and provide custom views to her teammates. Today this web database is ...(truncated)...
And the winner is
Abstract from InfoPath Team Blog (Indexed 2010-03-08):
The InfoPath Solution Video Contest is over! We assembled the team last Friday, and screened the final submissions, debated, re-watched, debated, re-screened again, and finally voted to determine the winners.The ContestantsBefore we announce the winners, lets review the contestants. At final count at the close of the contest (midnight on March 1st ), we had received three submissions:(1) Leave Request form Author: Clayton Cobb Company: Planet Technologies Clays solution allows members of his com...(truncated)...
Deploying your VSTO add-ins to All Users (Saurabh Bhatia)
Abstract from Paul Cornell (Indexed 2010-03-08):
An often-requested feature for VSTO add-ins is the ability to install an add-in for all users of a machine. Misha Shneerson had blogged about a workaround to enable this scenario here. This workaround is not recommended. Now, deploying an add-in to All Users is supported for both Microsoft Office 2007 (through a hotfix) and Microsoft Office 2010. Office 2010 With Office 2010, it is possible to directly register a VSTO add-in under the HKLM Office add-ins registry hive such that the add-in gets...(truncated)...
Spreading Out a Table
Abstract from Allen Wyatt's Excel Tips (Indexed 2010-03-08):
Need additional space in a table? You can quickly add any number of rows desired between each row of an existing table by using the handy macro presented in this tip.Read this ExcelTip: Spreading Out a TableMicrosoft Excel Tips - Learn Excel Faster!
Automatically Changing Dates
Abstract from Allen Wyatt's Word Tips (Indexed 2010-03-08):
The AutoCorrect feature can be a boon to productive typingexcept when things go wrong. This tip describes one such scenario, related to dates, and then explains how to fix it.Read this WordTip: Automatically Changing DatesMicrosoft Word Tips - Learn Word Faster!
Getting Array Data from a Filtered List in VBA
Abstract from Daily Dose of Excel (Indexed 2010-03-08):
Getting data from an Excel sheet into an array is usually best accomplished with a statement that looks something like this:vMyArray = Sheet1.UsedRange.ValueI thought it would be keen to fill an array from a filtered list, so I codedSub ArrFilteredList() Dim vArr As Variant vArr = Sheet1.UsedRange.SpecialCells(xlCellTypeVisible).Value [...]
More Stuff For JMT Excel Utilities
Abstract from Andrew's Excel Tips (Indexed 2010-03-07):
When I don't blog for a while, it could mean I've decided to become a normal human being (at least pretend) or I am up to something...Well, if you believe the former, I'm sure Santa or the Giant Intergalactic Popsicle will bring you a nice present thi...
Copying, Moving and Deleting Comments
Abstract from Allen Wyatt's Word Tips (Indexed 2010-03-07):
Comments are handy when you are developing a document. Copying, moving, and deleting the comments is relatively easy; all you need to do is use the editing techniques you are already using.Read this WordTip: Copying, Moving and Deleting CommentsMicrosoft Word Tips - Learn Word Faster!
Filling References to Another Workbook
Abstract from Allen Wyatt's Excel Tips (Indexed 2010-03-06):
When you create references to cells in other workbooks, Excel, by default, makes the references absolute. This makes it difficult to automatically fill a range of cells with relative references based on the created reference. This tip explains how you can get around this default Excel behavior.Read this ExcelTip: Filling References to Another WorkbookMicrosoft Excel Tips - Learn Excel Faster!
Automatically Saving Document Copies on Floppy
Abstract from Allen Wyatt's Word Tips (Indexed 2010-03-06):
WordPerfect included a command that allowed users to save a copy of their current document to the A: drive. Word has no similar command, but you can create your own that allows you to save document copies to any drive you want.Read this WordTip: Automatically Saving Document Copies on FloppyMicrosoft Word Tips - Learn Word Faster!