Tuesday, March 23, 2010

Excel VBA - "operation is not allowed when the object is closed"

This is normally caused by the stored procedure called, you will need to place 'set nocount on' on top of the SP to eliminate the extra information returned.

No comments:

Disable Microsoft Defender for Cloud for Visual Studio Subscription (MSDN)

I use a visual studio pro subscription which comes with $150 azure cloud credit, for some reason Microsoft Defender for Cloud was turned on ...