G
guhan
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
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