Archive for the ‘Templates’ Category.

Website update

This post introduces several new items on the www.tushar-mehta.com website.

New Workbook Task Pane

I’m having a small problem with the New Workbook Taskpane in Excel 2003 (11.6355.6360). I was investigating a problem dealing with application level events and book.xlt when I “discovered” that creating a new workbook from the task pane does not do what I expect. I created a template file named book.xlt and saved [...]

Tabs Under File New

When you select New from the File menu, the New dialog box is displayed. Usually, the New dialog will have some tabs that organize the templates that are available. This example has the General, Spreadsheet Solutions, and Office 97 Templates tabs.

You can add your own tabs to this dialog by adding subfolders to [...]

FUNCRES.XLA

Someone sent me an email asking what this add-in was, but my reply bounced, so I’m posting it here. This file is from the Analysis Toolpack (I mean Toolpak). It holds all the code for the ATP functions like NETWORKDAYS. If you see it in your Project Explorer in the VBE, but [...]