Compile error: Procedure does not match description....

[OldGrantonian]

.
I have Office 2010, Win 7 Home Premium SP 1. All Win updates applied.

I last used amateur's VBA with MS Word and MS Access about 15 years ago (VB 6). I have no Excel VBA experience.

When I tried to open a downloaded Excel file, there is an immediate jump to the following message:

- Compile error: Procedure does not match description of event or procedure having the same name

Do I need to find all the places where the procedure is used and check the type/number of arguments? If so, is there an easy way to find all the occurrences?

I would be most grateful for any advice.

Thanks.

[AB33]

What do you see when click the error?
I suspect you have two codes that have the same name.

[OldGrantonian]

What do you see when click the error?
I suspect you have two codes that have the same name.

The following line of code is highlighted. (I forgot to include this in my OP. Sorry.)

Private Sub m_TWSControl_orderStatus(ByVal id As Long, ByVal status As String, ByVal filled As Long, ByVal remaining As Long, ByVal avgFillPrice As Double, ByVal permId As Long, ByVal parentId As Long, ByVal lastFillPrice As Double, ByVal clientId As Long, ByVal whyHeld As String)

Thanks.

[AB33]

This procedure name is "m_TWSControl_orderStatus". Do you have another code with the same name?

Or you are trying to call this procedure from another one, but this is a private sub.

[OldGrantonian]

This procedure name is "m_TWSControl_orderStatus". Do you have another code with the same name?

Or you are trying to call this procedure from another one, but this is a private sub.

I searched for "m_TWSControl_orderStatus" in "Current Project" with only one result. That result is the line that was highlighted under the message box (see my previous post).

Does that indicate that the code is never called? Maybe I could comment out the sub to see what happens? (Edited: I think that probably makes no sense. I don't think code needs to be called?)

Thanks.

[AB33]

As it a sub with parameters, you can not run it directly, but called from another procedure with the right arguments.
Try to remove the private bit.


Sub m_TWSControl_orderStatus

Is it possible for you to attach the code with a sample book?

[aa4311j3]

Hi,

Did you ever get the IBExcelTrader to work after receiving the VBA compiling error?