If that's not clear, here's a screenshot of what I mean. I happen to be viewing that in Excel 2007 but they're using E2k3. This grouping/"outline" is an Excel thing. This was generated by an ...

We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell. In a recent series of posts, I explained how to launch a PowerShell script ...

The ability to automate tasks in Excel for the web has been a long wait—but it’s finally here, and it was worth the wait. One thing users have clamored for is web apps that support code (macros or ...

Back in December, I wrote about Microsoft’s decision to drop support for Visual Basic for Applications (VBA) from the next version of Office. I had, and still have, many concerns about the switch. The ...

Hi,<BR><BR>I'm debugging a Excel VBA script. The script uses the MkDir command to creates a directory.<BR><BR>however, if the directory already exists it gives out a ...