You didn't understand. I HAVE microsoft office professional version, simply
i need to run my *.bas without opening excel or word (for exemple) because i
need that program but i don't need to use office (the macro will open word,
only with particular conditions)...
Peraphs i must use VB?
I understand full well what you're trying to do; I'm just surprised that you
could have reached this point without a better understanding of the tools
you're working with.
VBA is an integral part of an application (that's exactly what the A in VBA
is all about): so you can't, by definition, use VBA without opening the
application it belongs to. If you want your code to run stand-alone, you
need VB.
You could use VB or VBscript to launch Word or Excel and start the
macro by automation.
But be clear on this point: the *macro* (the VBA code in the .bas
file) will not begin to run until after the Office app starts. Until
then, you must be running some other kind of code.
If you use VB, be aware that there are differences between VBA syntax
and VB syntax, even though they both use the .bas extension when you
save the code. You'll probably have to modify the code to get it to
run in VB.
Thank you very much. I'll begin to write VB code!
Peraphs you think that I ask a stupid thing, but you must know that in Italy
there aren't so many people knowing Office so well, so I never found anyone
who told what to do!!!
We often say that there is no such thing as a stupid question. If you
don't know something, ask -- that's why we're here.
If you haven't already found it, you may be interested in visiting
microsoft.public.it.office.word, which is an Italian-language
newsgroup for questions about Word.
WOW! I didn't konw! I subscrive now!!!
Many thanks!
Guido
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
