Stand Alone program

[Khalil Handal]

Hi,
It was suggested to put my post in this group!
I am not sure if this is the right group!

Is it possible to have a stand alone program (exe file for example) using
Visual Basic (OR maybe a worksheet) so as to:
when the program starts it has a menu with 12 names each name corresponds to
an Excel file in the same folder. When somone cliks on it the corresponding
Excel file will open.

 

[gimme_this_gimme_that]

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?

 

[Khalil Handal]

Thank a lot for the suggestions,
Having a menu will make it more easy for someone who don't know a lot about
computers and it it is also more fancy (good looking). Another reason is
that the files might be 24 files instead of 12.

Khalil