I am using VB6 and transferring data to an MS Excel 97 spreadsheet.

The prob is when I create an instance of XL:

Global gobjXLApp as Excel.Application 'Done in Global.bas

Set gobjXLApp = New Excel.Application 'done in frmMain.frm
'or alternatively I have used...
Set gobjXLApp = CreateObject("Excel.Application")
'The Excel 8.0 Object library is referenced

while either of the above methods works on my PC a PC here at work has the following error.

"Error 458: Variable uses an Automation type not supported in Visual Basic."

This error is caused by either of the above methods, but only on this one PC?

Both the PC I developed this code on and the troubled PC are running VB6 SP4, NT4 SP5, Office 97 SR2. Any ideas??

Cheers.