Which program?
 

I would be extremely grateful for any suggestions to help me start this
personal project.

I wish to change my multiple worksheet Excel file so that it runs more like
a powerpoint presentation or Website index page.

My intention is to have an initial MENU screen consisting of buttons.
Selection of each button will then open a new screen containing a specific
worksheet requiring either data entry or one that automatically performs a
calculation(s) using the data previously entered.

Each of these screens must contain both NEXT and RETURN buttons that will
move onto a new worksheet calculation or return to the MENU Screen.

Is there a suitable program that will enable me to achieve this? VISUAL
BASIC has been mentioned.

I would like to include an opening animation but this is not essential as it
could always be run separately.

I do not want to limit this program by being internet based.

Thanks,
John

Which program?
 

Dear Dear Sir,

It's not easy to recommend a program for this application without knowing
more about it. Many people use Excel where Access would be a better base.
No pun intended. It doesn't do animations, but you can build menus (on
Forms) that will appear automatically. It can be made to look like a custom
application without writing any macro code. Much more difficult in Excel,
which excels (again, no pun intended) in analysis, rather than
entry/storage/retrieval/output as with Access.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dear Sir" wrote in message
...
I would be extremely grateful for any suggestions to help me start this
personal project.

I wish to change my multiple worksheet Excel file so that it runs more
like
a powerpoint presentation or Website index page.

My intention is to have an initial MENU screen consisting of buttons.
Selection of each button will then open a new screen containing a specific
worksheet requiring either data entry or one that automatically performs a
calculation(s) using the data previously entered.

Each of these screens must contain both NEXT and RETURN buttons that will
move onto a new worksheet calculation or return to the MENU Screen.

Is there a suitable program that will enable me to achieve this? VISUAL
BASIC has been mentioned.

I would like to include an opening animation but this is not essential as
it
could always be run separately.

I do not want to limit this program by being internet based.

Thanks,
John

Which program?
 

Thank you for your prompt response Earl.

The Excel worksheets are to perform fairly straightforward functions e.g.
Sort, 'If..Then' etc. I would just like each worksheet to open and
autocalculate when an on-screen NEXT button is pressed. The best analogy I
can make is that of feeling like an RPG

"Earl Kiosterud" wrote:

Dear Dear Sir,

It's not easy to recommend a program for this application without knowing
more about it. Many people use Excel where Access would be a better base.
No pun intended. It doesn't do animations, but you can build menus (on
Forms) that will appear automatically. It can be made to look like a custom
application without writing any macro code. Much more difficult in Excel,
which excels (again, no pun intended) in analysis, rather than
entry/storage/retrieval/output as with Access.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dear Sir" wrote in message
...
I would be extremely grateful for any suggestions to help me start this
personal project.

I wish to change my multiple worksheet Excel file so that it runs more
like
a powerpoint presentation or Website index page.

My intention is to have an initial MENU screen consisting of buttons.
Selection of each button will then open a new screen containing a specific
worksheet requiring either data entry or one that automatically performs a
calculation(s) using the data previously entered.

Each of these screens must contain both NEXT and RETURN buttons that will
move onto a new worksheet calculation or return to the MENU Screen.

Is there a suitable program that will enable me to achieve this? VISUAL
BASIC has been mentioned.

I would like to include an opening animation but this is not essential as
it
could always be run separately.

I do not want to limit this program by being internet based.

Thanks,
John

Which program?
 

John,

This really isn't enough to go on to give a recommendation. In Excel,
you'll have to do pretty much all of the work yourself, including setting up
hyperlinks, possibly writing code to copy data to its destination, clearing
the existing data, and other stuff. In Access, you can do all that without
writing any code. In short, if you don't have a lot of in-depth analysis,
and are mostly entering/storing/retrieving data, with simple calculations
(totals, etc), Access will do more for less. If you do have a lot of
analytical requirements, Excel is your tool, but be prepared to do some
work. I'm sorry, but I just can't get you there from here.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dear Sir" wrote in message
...
Thank you for your prompt response Earl.

The Excel worksheets are to perform fairly straightforward functions e.g.
Sort, 'If..Then' etc. I would just like each worksheet to open and
autocalculate when an on-screen NEXT button is pressed. The best analogy
I
can make is that of feeling like an RPG

"Earl Kiosterud" wrote:

Dear Dear Sir,

It's not easy to recommend a program for this application without knowing
more about it. Many people use Excel where Access would be a better
base.
No pun intended. It doesn't do animations, but you can build menus (on
Forms) that will appear automatically. It can be made to look like a
custom
application without writing any macro code. Much more difficult in
Excel,
which excels (again, no pun intended) in analysis, rather than
entry/storage/retrieval/output as with Access.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dear Sir" wrote in message
...
I would be extremely grateful for any suggestions to help me start this
personal project.

I wish to change my multiple worksheet Excel file so that it runs more
like
a powerpoint presentation or Website index page.

My intention is to have an initial MENU screen consisting of buttons.
Selection of each button will then open a new screen containing a
specific
worksheet requiring either data entry or one that automatically
performs a
calculation(s) using the data previously entered.

Each of these screens must contain both NEXT and RETURN buttons that
will
move onto a new worksheet calculation or return to the MENU Screen.

Is there a suitable program that will enable me to achieve this?
VISUAL
BASIC has been mentioned.

I would like to include an opening animation but this is not essential
as
it
could always be run separately.

I do not want to limit this program by being internet based.

Thanks,
John

Which program?
 

Thanks Earl,

It always appeared that the macros I have used in Excel were going to be the
best option for what I intended. I just wanted to ensure that I wasn't
missing a better alternative.

Regards
John

"Earl Kiosterud" wrote:

John,

This really isn't enough to go on to give a recommendation. In Excel,
you'll have to do pretty much all of the work yourself, including setting up
hyperlinks, possibly writing code to copy data to its destination, clearing
the existing data, and other stuff. In Access, you can do all that without
writing any code. In short, if you don't have a lot of in-depth analysis,
and are mostly entering/storing/retrieving data, with simple calculations
(totals, etc), Access will do more for less. If you do have a lot of
analytical requirements, Excel is your tool, but be prepared to do some
work. I'm sorry, but I just can't get you there from here.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dear Sir" wrote in message
...
Thank you for your prompt response Earl.

The Excel worksheets are to perform fairly straightforward functions e.g.
Sort, 'If..Then' etc. I would just like each worksheet to open and
autocalculate when an on-screen NEXT button is pressed. The best analogy
I
can make is that of feeling like an RPG

"Earl Kiosterud" wrote:

Dear Dear Sir,

It's not easy to recommend a program for this application without knowing
more about it. Many people use Excel where Access would be a better
base.
No pun intended. It doesn't do animations, but you can build menus (on
Forms) that will appear automatically. It can be made to look like a
custom
application without writing any macro code. Much more difficult in
Excel,
which excels (again, no pun intended) in analysis, rather than
entry/storage/retrieval/output as with Access.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Dear Sir" wrote in message
...
I would be extremely grateful for any suggestions to help me start this
personal project.

I wish to change my multiple worksheet Excel file so that it runs more
like
a powerpoint presentation or Website index page.

My intention is to have an initial MENU screen consisting of buttons.
Selection of each button will then open a new screen containing a
specific
worksheet requiring either data entry or one that automatically
performs a
calculation(s) using the data previously entered.

Each of these screens must contain both NEXT and RETURN buttons that
will
move onto a new worksheet calculation or return to the MENU Screen.

Is there a suitable program that will enable me to achieve this?
VISUAL
BASIC has been mentioned.

I would like to include an opening animation but this is not essential
as
it
could always be run separately.

I do not want to limit this program by being internet based.

Thanks,
John