Hi,
I have written a vb application that calls a macro in an excel file ,
i open the file containing the macro and call the macro on another
file which i open in the same application window,
now , the macro is called perfectly (xyz.xls!macro1)
but when i want to call the macro again , i must have closed the
instance of excel .
I am not able to close the excel application completely , there is
some File reservation error that pops up

i am using the xlapp.close and set xlapp=nothing to kill the excel ,

plez, some one provide help ,
is there any other methiod to use the macro in the excel file ,
for info sake , the macro is to insert a dummy record in any excel
file ,

thanks
hoping to get good responses

cheers

make sure that you set any objects tied to the excel app
= nothing, such as workbooks, worksheets etc.

so after you closed all books and set the workbook etc
variables = nothing

xlApp.QUIT
set xlApp = Nothing

Patrick Molloy
Microsoft Excel MVP


-----Original Message-----
Hi,
I have written a vb application that calls a macro in an
excel file ,
i open the file containing the macro and call the macro
on another
file which i open in the same application window,
now , the macro is called perfectly (xyz.xls!macro1)
but when i want to call the macro again , i must have
closed the
instance of excel .
I am not able to close the excel application
completely , there is
some File reservation error that pops up

i am using the xlapp.close and set xlapp=nothing to kill
the excel ,

plez, some one provide help ,
is there any other methiod to use the macro in the excel
file ,
for info sake , the macro is to insert a dummy record in
any excel
file ,

thanks
hoping to get good responses

cheers
.