New Excel.Application failed

[jcgillies]

Hello,

I am struggling to understand why one of my code is not working. I have attached a screen shot of the problem and the references that I have already. It went from working to not working. I have search all over the net and have seen that the code is correct.



Is there something I am doing wrong? When I click the button it throws that message and highlights "New Excel.Application"

Many thanks in advance and many thanks to this forum, it has help me get out of a pickle on numerous times.

[alansidman]

perhaps you need to define ObjXL. ie Dim ObjXL as New Excel.Application

[jcgillies]

Hi,

many thanks, I tried that it still threw out the error. I cant see why it would throw an error.

Many thanks alansidman

[davegri]

Private sub cmd_8_Click()
    Dim objXL as object
    Dim objWkbT as object

I think you need to declare the objects before you Set them. Try adding these two lines.

[ssanfu]

A lot depends on whether you are trying to use early binding or late binding.
I set a reference to the "Microsoft Excel 15.0 Object Library" when trying to use Excel automation. (but for me, it is "Microsoft Excel 14.0 Object Library" since I have Office 2010)