Quitting Excel application(2003) from one of the word(2003) module.

[samkumar]

HI guys,
I have this word(2003) template which has one module, one "userForm" and one "ThisDocument" word object(which contains the main codes). The Excel.Application is created in "ThisDocument" and then the rest of the codes run. Some where the code jumps to module 1 and then jumps to "userForm".
I want to know the syntax or codes that can be used in "userForm" programming section that quits the Excel.Application that was created in "ThisDocument".
I tried using

but didnt work.

Thanks in advance,

Sam.

[JosephP]

if you have a variable holding the reference to the excel application then it's
variable_name.quit

[samkumar]

Hi JP,

The object variable holding the refernce to the Excel application is oXL which is in "ThisDocument" editor window. I want Excel application to quit from "userForm" editor window.

Sam

[JosephP]

if oXL is declared as Public in the ThisDocument module then

Please Login or Register  to view this content.

oughta do it.

[samkumar]

exactly!! i did the same thing. i declared oXL as public in "ThisDocument" module and then i used the code

Please Login or Register  to view this content.

in "userForm" module. An error message appears saying "object variable or with-block variable not specified/defined"

[JosephP]

then I guess you haven't run the code to initialize the variable or you have subsequently set it to nothing

[samkumar]

I havent set it to nothing anywhere in between. could there be any other mistakes? or should i use "with"

Sam.

[JosephP]

how would 'with' help you? if there's no object reference set, you can't hold a reference to it with 'with' ;-)
I reckon we need to see all the code or preferably the document

[samkumar]

i meant fo example :

Please Login or Register  to view this content.

It doesnt seem to work.

I then tranferred all the codes from "ThisDocument" module to a new module(module2) and then i used the codes

Please Login or Register  to view this content.

it seems to work. But then the command buttons on the word template trigger the macros only when the codes are in "ThisDocument" module.

I am not allowed to show the document because it violates my employers rules(hope you understand)..

Sam