Open a separate instance of Excel to do your processing.
Keep the new instance invisible (the default state). See...
http://support.microsoft.com/kb/219151/en-us
Jim Cone
Portland, Oregon USA
"Naveen J V"
wrote in message
Hi,
I have a
VB programmming coded by my senior programmers.
It will take data from Access database and put it into an excel
file and formats. Since we require a lot of formating after the data
being spooled to excel we have written a
VB code.
When we run
VB programs it opens the excel sheet in the background
and does its work. If we open excel directly for any other purpose
will get runtime error from
VB application and program aborts.
Is there any method by which we can use excel in parallel to the
application (which uses excel internally)?
Please let me know if you have any solutions
Regards,