Working with MS Office 2000

Now, I've downloaded some templates, and have seen some finish work after
people have programmed certain excel things. After your done with the
programing, and you have everything you want; can I open up the program (like
a program) without having all of the excel work sheets around it? Just the
program alone!!!

Thanks,

Eric

You have to have excel running for your macros to work.

But you could hide the application if all you wanted to show was a userform (or
two).

There are questions (and responses) asking how to hide toolbars to make excel
look different. You can search google if that appeals to you.

But there are other standalone programming languages that may be better suited
(Visual Basic)???



jungleman wrote:

Working with MS Office 2000

Now, I've downloaded some templates, and have seen some finish work after
people have programmed certain excel things. After your done with the
programing, and you have everything you want; can I open up the program (like
a program) without having all of the excel work sheets around it? Just the
program alone!!!

Thanks,

Eric

--

Dave Peterson

It's not possible to "compile" an Excel VBA project into a standalone
"program".

However, you have options, including:

1. Make an add-in (xla) from your code
2. Place the code in your "personal.xls" workbook, so it will always be
available whenever Excel is open.

Difficult to suggest what the best approach might be without details such as
what your code is intended to do, and whether/how you want to be able to
distribute it.


Tim.



"jungleman" wrote in message
...
Working with MS Office 2000

Now, I've downloaded some templates, and have seen some finish work after
people have programmed certain excel things. After your done with the
programing, and you have everything you want; can I open up the program
(like
a program) without having all of the excel work sheets around it? Just
the
program alone!!!

Thanks,

Eric

The only thing Tim, is that I'm not that familiar with this code thing. I
know less than a handfull of code commands. I was able to put my program
togeher with a lot of questions and trial and error. If you would be so kind
to enlighten me on a few tricks and deals, I would greatly appreciate it.
*I'm a nurse, and I am making this program as a reference for myself and
others. I would like to use the program, like a regular program. There's a
few glitches though. I have Tabs at the top of the form, to switch from
reference to reference. Something happened, that when I press on a tab, the
page will sort of flicker,and go to the desired page, but it also
automatically scrolls down a bit just below the tabs, so that everytime I
want to press another Tab, I have to scroll back up.

Anyway, big question!!!!!
If you can help, that'd be great.

Thanks,
Eric

"Tim Williams" wrote:

It's not possible to "compile" an Excel VBA project into a standalone
"program".

However, you have options, including:

1. Make an add-in (xla) from your code
2. Place the code in your "personal.xls" workbook, so it will always be
available whenever Excel is open.

Difficult to suggest what the best approach might be without details such as
what your code is intended to do, and whether/how you want to be able to
distribute it.


Tim.



"jungleman" wrote in message
...
Working with MS Office 2000

Now, I've downloaded some templates, and have seen some finish work after
people have programmed certain excel things. After your done with the
programing, and you have everything you want; can I open up the program
(like
a program) without having all of the excel work sheets around it? Just
the
program alone!!!

Thanks,

Eric

Eric

If you'd like to send me your workbook via e-mail I will try to take a
look at your problem.

Tim.


"jungleman" wrote in message
...
The only thing Tim, is that I'm not that familiar with this code
thing. I
know less than a handfull of code commands. I was able to put my
program
togeher with a lot of questions and trial and error. If you would
be so kind
to enlighten me on a few tricks and deals, I would greatly
appreciate it.
*I'm a nurse, and I am making this program as a reference for myself
and
others. I would like to use the program, like a regular program.
There's a
few glitches though. I have Tabs at the top of the form, to switch
from
reference to reference. Something happened, that when I press on a
tab, the
page will sort of flicker,and go to the desired page, but it also
automatically scrolls down a bit just below the tabs, so that
everytime I
want to press another Tab, I have to scroll back up.

Anyway, big question!!!!!
If you can help, that'd be great.

Thanks,
Eric

"Tim Williams" wrote:

It's not possible to "compile" an Excel VBA project into a
standalone
"program".

However, you have options, including:

1. Make an add-in (xla) from your code
2. Place the code in your "personal.xls" workbook, so it will
always be
available whenever Excel is open.

Difficult to suggest what the best approach might be without
details such as
what your code is intended to do, and whether/how you want to be
able to
distribute it.


Tim.