>Larry,
>
>By "simultaneous connections", I mean two separate object links to Excel... such as,
>
>
>oExcel1 = CreateObject("Excel.Application")
>oExcel2 = CreateObject("Excel.Application")
>
>
>This way, I can send data to cells in two different spreadsheets, depending on the kind of data being processed. However, the application was encountering a 1426 error when I had two connections, versus no error while working with a single connection.
I never had a problem doing this. Two completely separate instances of Excel accessing different spreadsheets in different threads. Unless there is a resource problem (e.g. memory) on the machine, I can't think of a reason for this to occur.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao