When a VBA solution falls short of your needs, there's probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work.

Microsoft recently announced a developer preview release supporting JavaScript to create custom functions directly in Excel. This addition moves beyond the existing Microsoft Office JavaScript API ...