web calls from VBA



  • 1. Word mail merge data source
    I am trying to use VB using OLE to change the datasource in a Word mail merge file to a server drive from the C: drive. When I try to make this change to another location on the C drive, there is no problem. When I try to use the UNC path to the server drive, I get an OLE Exception error. Anyone have a similar problem, or have any ideas on why Word will not let me make this change to the datasource location? Any ideas on how to get around the problem? Any and all ideas appreciated, Mark
  • 2. Automatically change a checkbox in word to checked from excel
    Can I make a checkbox change from unchecked to checked based on data from a cell in an Excel program?
  • 3. How to dynamically use fields to setup hiperlinks?
    I want to know if there is a way to dynamically setup hiperlinks using fields. I already have a template with titles, which I want to assign a link without selecting the hyperlink icon and then the address. Is it possible in word?
  • 4. Redirecting output of a command in a macro
    I'm trying to do something similar to redirecting output in DOS and shell scripting, where you can use the output from one command as the input for another command. I'm trying to create a macro that will create a bookmark name by copying and pasting a bit of text from the document. At one point in the macro there is this command: Selection.Copy This copies the text that I want to use as a macro name. Later, there is this section: With ActiveDocument.Bookmarks .Add Range:=Selection.Range, Name:="Bkmk1" .DefaultSorting = wdSortByName .ShowHidden = False The problem is, every time I run the macro, it uses "Bkmk1" as the input for the bookmark name. Is there a way to set the text copied in the first command as a variable, and then use the value of that variable for the bookmark name?
  • 5. Locking formfields after update
    I am working on a project which includes an approval process. The process is called from an Access form and utilizes Outlook's 'Assign Task' function. The code I have written starts when a Command button on the Access form is clicked. It opens a Word document, enters data from the Access form to three text fields in the document, then renames (using data from those textboxes) and saves the document. I then have a 'task' assigned to the next person in the approval process (the document is added as an attachment), who opens the attachment, enters their info, crtl+s to save it and assigns the task to the next person in the process. Repeat twice. What I want to know is: Is it possible to lock formfields (I have 2 textboxs [1 for Username and 1 for Date] and a checkbox for each step in the process) to prevent any changes once the document is saved? I have searched the Discussion Group and Googled but didn't find my scenerio...... thanks in advance, you people are a GREAT resource! Stu

web calls from VBA

Postby Liz » Sun, 17 Sep 2006 07:26:30 GMT

I have to use an API built in the dot net 2.0 framework to put some
information from a database into a Word 2003 template. I was going to
use VSTO, but the desktop at my firm only has the 1.x framework
installed.  The solution I was thinking of was to put the API on a
server with the 2.0 framework and use web calls from VBA on the client
PC.  Is this possible?  And where can I find resources to learn how to
do it?



Similar Threads:

1.Calling Google Web Service in VBA using Web Services Toolkit - Invalid OLEVERB structure error

2.Calling a Java Web Service in VBA

Hi all!
I've built a java web service and i want to use i in a simple vba 
application in Word
can i use a java web service inside the vba code?

thank you! 

3.VBA Call to Web Services

'm trying to call a web service created in VB.NET from VBA in MS Excel
2003.  The web service requires a double precision array to be passed
in but VBA doesn't seem to be able to make the call without bombing
out.  Is there something special that must be done in using arrays
between VBA and VB.NET web services?

4.Problem calling C# web service with Ref parameter from a VB.NET Web application


I have an asp.net Web app in vb.net trying to call a C# web service
which takes a reference parameter. I tried a simple C# web app to call
the Web service and it works perfectly. However, when I try it in the
vb.net web app, I run into XML definition errors. Looks like the proxy
class is not able to generate the correct XML with the ref parameter.
Here is error:

The element 'urn:test-com:document:test:rfc:functions:T_RETURN has
invalid child element 'urn:test-com:document:test:rfc:functions:item'.
Expected 'urn:test-com:document:test:rfc:functions:ITEM_NUMBER

Here is how I am declaring the ref parameter in vb.net

Dim oReturnObj(0) as com.abc.qa.ZRETURNOBJ
oReturnObj(0) = New com.abc.qa.ZRETURNOBJ

Any help will be great.


5.Call web services which displays an ASP web page

Is it possible to return a form as the output from calling a web
service.  In other words, could I create a web service and have it
return a web page with data filled out from the call?

6. Error from VBA call to WEb service via webservicereferences ver 2.0

7. Calling Reporting Services Web Service from MS Access?

8. Calling web services with complex type input parameters

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 51 guest