Can SOAP use with Office 2000?

S

s y shum

I call a VBA function that use SOAP in a Word97, it is worked well. A
selection box will be pop up when running the VBA. However after upgraded
the MS Office to Office 2000, the VBA function is not working properly,
screen is hange while runing the VBA. Can SOAP use with office2000? Can
anyone suggest a way to fix this problem?
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?cyB5IHNodW0=?=,
I call a VBA function that use SOAP in a Word97, it is worked well. A
selection box will be pop up when running the VBA. However after upgraded
the MS Office to Office 2000, the VBA function is not working properly,
screen is hange while runing the VBA. Can SOAP use with office2000? Can
anyone suggest a way to fix this problem?
Since using SOAP almost certainly involves referencing a non-Office object
library, there shouldn't be any reason you can't use SOAP in Office 2000 same
as in Office 97. Theoretically.

If you've set a reference to the object library (rather than using
late-binding), you might check whether the Office 2000 installation has the
same library version installed as the Office 97 one.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :)
 
S

s y shum

Cindy M -WordMVP- said:
Hi =?Utf-8?B?cyB5IHNodW0=?=,

Since using SOAP almost certainly involves referencing a non-Office object
library, there shouldn't be any reason you can't use SOAP in Office 2000 same
as in Office 97. Theoretically.

If you've set a reference to the object library (rather than using
late-binding), you might check whether the Office 2000 installation has the
same library version installed as the Office 97 one.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)


This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :)
It is found that the VBA hung whenever it is related to a Form input or
selection. The problem seems related to the form enabled function. I debug
the VBA and have the following findings:
- If the code "Me.Enable = True" is being executed on the script (i.e. use
F8 to go next code), the VBA will be run normally.
- If the code "Me.Enable = True" is set as break point but use F5 to execute
it, the VBA will hung in the pop up selection box.
Is anyone come across this case and know how to fix it?
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?cyB5IHNodW0=?=,
It is found that the VBA hung whenever it is related to a Form input or
selection. The problem seems related to the form enabled function. I debug
the VBA and have the following findings:
- If the code "Me.Enable = True" is being executed on the script (i.e. use
F8 to go next code), the VBA will be run normally.
- If the code "Me.Enable = True" is set as break point but use F5 to execute
it, the VBA will hung in the pop up selection box.
Is anyone come across this case and know how to fix it?
Can you specify which kind of "Form" you mean? With Word, this could be
- form fields
- ActiveX controls
- a VBA UserForm

And also post the section of code where you're seeing the problem?

Also, in which programming environment are you working? Is this the Word VBA
environment, or something else?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :)
 
S

s y shum

Cindy M -WordMVP- said:
Hi =?Utf-8?B?cyB5IHNodW0=?=,

Can you specify which kind of "Form" you mean? With Word, this could be
- form fields
- ActiveX controls
- a VBA UserForm

And also post the section of code where you're seeing the problem?

Also, in which programming environment are you working? Is this the Word VBA
environment, or something else?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)


This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :)
That should be a VBA UserForm. The VBA program (in .dot format) is triggered
by a user define button on the menu bar in Word document. Here is the
coding that I found the problem:

Private Sub UserForm_Activate()
Dim varUser As Variant
On Error GoTo UserForm_Activate_Err1
If Not m_blnFormActivated Then
Me.Enabled = False 'disable the action on form in case there is
data loading
'inform user it is loading
Call ClearLabel(lblStatusBox, "Loading user information...")
Call GetIdentity(varUser, "", "M")

If IsArray(varUser) Then
'load the info to box
LoadArrayToBox cmbUser, varUser, True, False, True
Else
MsgBox "No valid user is available", vbCritical + vbOKOnly +
vbDefaultButton1, MSG_TITLE
Unload Me
Exit Sub
End If
Call ClearLabel(lblStatusBox)

Me.Enabled = True <----- problem encounter here

m_blnFormActivated = True
End If
Exit Sub
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?cyB5IHNodW0=?=,

I've never come across anything like this before, but I can sorta see where
there might be a problem in how this is constructed. I'd try putting the
command to re-enable the form in a procedure that follows UserForm_Activate?
That should be a VBA UserForm. The VBA program (in .dot format) is triggered
by a user define button on the menu bar in Word document. Here is the
coding that I found the problem:

Private Sub UserForm_Activate()
Dim varUser As Variant
On Error GoTo UserForm_Activate_Err1
If Not m_blnFormActivated Then
Me.Enabled = False 'disable the action on form in case there is
data loading
'inform user it is loading
Call ClearLabel(lblStatusBox, "Loading user information...")
Call GetIdentity(varUser, "", "M")

If IsArray(varUser) Then
'load the info to box
LoadArrayToBox cmbUser, varUser, True, False, True
Else
MsgBox "No valid user is available", vbCritical + vbOKOnly +
vbDefaultButton1, MSG_TITLE
Unload Me
Exit Sub
End If
Call ClearLabel(lblStatusBox)

Me.Enabled = True <----- problem encounter here

m_blnFormActivated = True
End If
Exit Sub

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top