Stand Alone program
 

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.

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?

Stand Alone program
 

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

wrote in message
oups.com...
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?