Concurrent using problem.

[ramkumar_cpt]

Hi,

this my coding for dynamic chart creation using vb(dll).


Dim xlApp As Excel.Application
Dim xlWrkbk As Excel.Workbook
Dim objWorkSheet As Excel.Worksheet
Set xlApp = New Excel.Application
xlApp.Visible = False

'// Open the Report Excel and the Full Template Excel
Set xlWrkbk = xlApp.Workbooks.Open(OutputFileName & ".xls")



And some coding for Chart creation.
......

......


xlApp.Application.DisplayAlerts = False
Set objWorkSheet = Nothing
xlWrkbk.Close
xlApp.Application.Quit

Set xlWrkbk = Nothing
Set xlApp = Nothing


I am calling this dll from ASP. The ASP and dll files are in
server(Networking). Actually its work fine. Actually my problem is if
one user access this chart creation dll, it is working fine and the
report generating well. But if 2 or more user access the same dll at
the same time, the chart creation of 1st user excel is stopped in the
middle. It will continue after finishing the second user excel.

I want to run the both the excel at same time simultaniously. I used
macro coding for creating the chart. pls help..

Thanks...

Ram kumar.R