Click here to Skip to main content
15,890,438 members

Articles by Steve L. Powell (Articles: 2, Technical Blogs: 8)

Articles: 2, Technical Blogs: 8

RSS Feed

Average article rating: 4.17

Desktop Programming
WPF
9 Jul 2012   Updated: 2 Aug 2012   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: CPOL    Views: 29,232     Bookmarked: 17   Downloaded: 346
Please Sign up or sign in to vote.
A technique to create a Dynamic View Model that handles enums.
Productivity Apps and Services
Microsoft Office
29 Jul 2012   Updated: 29 Jul 2012   Rating: 3.33/5    Votes: 3   Popularity: 1.59
Licence: CPOL    Views: 20,074     Bookmarked: 10   Downloaded: 19
Please Sign up or sign in to vote.
IntroductionWhy would you  want to call an RTD from an XLL? Recall that the way to call an RTD is through the RTD function in Excel, so the user needs to somehow remember how many parameters your function takes and in what order to supply them and even what the function is called. Good luck explaini

Average blogs rating: 4.79

Operating Systems
Windows
22 Aug 2011   Updated: 22 Aug 2011   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: CPOL    Views: 17,290     Bookmarked: 2   Downloaded: 0
Please Sign up or sign in to vote.
Automation Add-In
25 Aug 2011   Updated: 7 Sep 2011   Rating: 4.56/5    Votes: 6   Popularity: 3.54
Licence: CPOL    Views: 53,101     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
In the previous article we developed a custom function in Excel using an Automation Add-in. It was fairly straightforward and didn’t take  long but performance isn’t one of it’s strengths and there is no way to properly document it within Excel for the user. The RTD is an automation add-
7 Sep 2011   Updated: 7 Sep 2011   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 11,140     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
COM and .NET: Cleaning up
Productivity Apps and Services
Microsoft Office
17 Aug 2011   Updated: 17 Aug 2011   Rating: 4.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 19,512     Bookmarked: 9   Downloaded: 0
Please Sign up or sign in to vote.
This is a guide to writing custom functions in Excel
13 Jul 2012   Updated: 13 Jul 2012   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 17,276     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
XLLs are significantly faster, and allow the developer to define the names/parameters of the functions.
Programming Languages
C#
6 Sep 2011   Updated: 6 Sep 2011   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 12,171     Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
The need for speed: Excel Buffer Class
Visual Basic
13 Mar 2011   Updated: 18 Mar 2011   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: CPOL    Views: 14,591     Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
Using Forms with Queries in Access
VBA
20 Feb 2011   Updated: 20 Feb 2011   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: CPOL    Views: 14,301     Bookmarked: 6   Downloaded: 0
Please Sign up or sign in to vote.
Sorting worksheets in Excel using VBA

Average tips rating:

No tips have been posted.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.
Software Developer Excel Adviser
Canada Canada
I am a freelance software developer with a variety of different interests. My main area of expertise is Microsoft Office add-ins (Excel/Outlook mostly) but I also develop Windows applications, Access Databases and Excel macros . I develop in VBA, C# and C++. My website exceladviser.com has articles on Excel, Access, Microsoft Office development, and general Windows programming (WPF, etc.).