Hi,

I am using VB 6.0 to automate some reports in excel. For every report there is a new VB project/VB executable.

My Program does following;
Creating a reference to Excel.Application object
Opening an excel template
Putting data in excel worksheets
Saving excel workbook with different name
Closing excel workbook

Problem
When two of my executables run at the same time, since they both are referencing excel object, they got failed, none of them is able to create excel report.

Please let me know if there is any workaround otherwise we may use threads in VB 6 or we can also move on to the .NET. But before that we need to find some workaround in VB 6 other than threading.

Thanks a lot guys,
M.Ahmar