View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] gimme_this_gimme_that@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 236
Default Stand Alone program

You can do either.

You can create an hta file (like and html page) and configure things
so that upon clicking on a button or an achor tag (or whatever) excel
opens a new Workbook with a new workfile.

You can also create an Excel Workbook that would do the job.

Most people would do it in Excel.

With HTA solution:

Disadvanges:

1. Users must lower security settings,
2. It's harder to maintain (the developer must know VBScript,WScript,
and Excel)

Advantage:

1. Looks cool. The menu page can reside on a webserver and looks like
a web page.

With Excel solution:

Advantages:

1. Keep existing security settings,
2. Any Excel programmer who knows VBA can maintain it.

Disadvantage:

Users will want to open Workbooks themselves. Why go through menu
workbook?