Error on compiling objects with Automation Variables.

Shalu

Hello everyone,

I am getting an issue with excel automation variables.

I have defined my variables as shown below

Name DataType Subtype
xlApp Automation 'Microsoft Excel 12.0 Object Library'.Application
xlWorkBook Automation 'Microsoft Excel 12.0 Object Library'.Workbook
xlWorkSheet Automation 'Microsoft Excel 12.0 Object Library'.Worksheet
xlWorkSheet1 Automation 'Microsoft Excel 12.0 Object Library'.Worksheet
xlWorkSheet2 Automation 'Microsoft Excel 12.0 Object Library'.Worksheet
xlWorkSheet3 Automation 'Microsoft Excel 12.0 Object Library'.Worksheet
xlWorkSheet4 Automation 'Microsoft Excel 12.0 Object Library'.Worksheet


But when i compile the object,I get the following error
"Could not load the selected library type"

Can anyone please help?

Thanks.

ta5

Hi Shalu
The reason is: On the client you are executing the compilation, there is no excel (or the wrong version) installed. Can you check this?
Hope this helps
Thomas

Shalu

Thank you indeed Thomas for your help.

ta5

Welcome!