EXCEL stop when 'createPosition'

4 posts / 0 new
Last post
PascalSonia
EXCEL stop when 'createPosition'

Hy,

I have a very bad mistake with my EXCEL tool.
EXCEL work with the API rest without error during many hours and... without any reason, EXCEL stop (freeze) with no message, no mean to go to DEBUG mode. The solution is to make ALT-F4 and force de closure of EXCEL.

With patience and several trial, I found the problem on the line 'Call oXMLHTTP.send(requestBodyString)'
=> The problem is random because I open some positions before !

I'm going to make an other try to confirm the problem for this line.

It's very frustrating because my macro works fine during a long time before the.. Arrghhh

Thanks

Pascal

PS :
The object is created with : 'Set oXMLHTTP = CreateObject("MSXML2.XMLHTTP.6.0")'

I use the EXCEL complement:
- Visual Basic For Applications
- Microsoft Excel 14.0 Object Library
- OLE Automation
- Microsoft Office 14.0 Object Library
- Microsoft HTML Object Library
- Microsoft Internet Controls
- Microsoft Forms 2.0 Objects Library
- Microsoft ActiveX Data Objects 6.1 Library
- Microsoft ActiveX Data Objects Recordset 6.0 Library
- Microsoft Scriping Runtime

Chris
EXCEL stop when 'createPosition'

Hey PascalSonia,

This appears to be a connection issue, and we haven't had another other reports like this.

Are you still experiencing issues?

Thanks,
Chris

PascalSonia
When I use the API 64 bit

When I use the API 64 bit with EXCEL 32 bit on Win 64 bit... I have this error.

API 32 bit and new life without error ;)

Thanks

Pascal

Chris
When I use the API 64 bit

Hi PascalSonia,

That's correct. You'll need to use the 32-bit version of the Excel API Sample if you have 32-bit Excel installed.

Thanks,
Chris

Log in or register to post comments