Forum Discussion

vthomeschoolmom's avatar
vthomeschoolmom
Super Contributor
13 years ago

MS Word automation and getting to the objects

Does anyone have examples of the very BASICS of interacting with MS Word objects with TC? I would like to know how to get a handle on the Selection object of the current selection in the currently ope...
  • HKosova's avatar
    HKosova
    8 years ago
    dasabaja wrote:

    After implementing the line that opens the document I got a different error.

    TypeError
WordDoc.Variables is not a function
Error location:
Unit: "HR\HR SmartTemplates\Script\Unit1"
Line: 8 Column: 26.

    Any hints on what this might be?

    Change Variables("Group") to Variables.Item("Group"). The former is VBA/VBScript syntax, but in other languages you need to use the .Item() method to access collection items in MS Office COM objects.

tristaanogre's avatar
tristaanogre
Esteemed Contributor

The error you're getting means that the WordDoc variable is not getting anything.  Not sure why the ActiveDocument call is not working.

 

Try the following instead.  Make sure that Word is closed and not running and do the following:

 

function myFunc (){

var objWordApplication = Sys.OleObject("Word.Application");

objWordApplication.Documents.Open(myDocumentPath);

var WordDoc= objWordApplication.ActiveDocument;
var myVariable = WordDoc.Variables("Group").Value;

Log.Message(myVariable)

}

Replace the bold with the actual file path and name of the document.  See if that works.

 

dasabaja's avatar
dasabaja
Occasional Contributor
8 years ago

Hi, tristaanogre.

 

Sorry for the late reply, I wasn't in my office during the weekend.

 

After implementing the line that opens the document I got a different error.

 

TypeError
WordDoc.Variables is not a function
Error location:
Unit: "HR\HR SmartTemplates\Script\Unit1"
Line: 8 Column: 26.

Any hints on what this might be?

  • HKosova's avatar
    HKosova
    SmartBear Alumni (Retired)
    8 years ago
    dasabaja wrote:

    After implementing the line that opens the document I got a different error.

    TypeError
WordDoc.Variables is not a function
Error location:
Unit: "HR\HR SmartTemplates\Script\Unit1"
Line: 8 Column: 26.

    Any hints on what this might be?

    Change Variables("Group") to Variables.Item("Group"). The former is VBA/VBScript syntax, but in other languages you need to use the .Item() method to access collection items in MS Office COM objects.

    • dasabaja's avatar
      dasabaja
      Occasional Contributor
      8 years ago

      Thank you HKosova! Adding the ".Item()" made my function work. 
      Here is the final version:

      function myFunc (){

var objWordApplication = Sys.OleObject("Word.Application");
objWordApplication.Documents.Open('C:\InvoiceLatTemplate.doc');

//objWordApplication.Visible = true;
var WordDoc = objWordApplication.ActiveDocument;
var myVariable = WordDoc.Variables.Item("Group").Name;
var myVariable1 = WordDoc.Variables.Item("Group").Value;

Log.Message(myVariable)
Log.Message(myVariable1)

}

      Both name and value are logged properly.

       

      One final question: is there a way to iterate through all the variables in a Word file? I have that function that itterates in VBA, but obviously TC script and VBA are not the same...

      • HKosova's avatar
        HKosova
        SmartBear Alumni (Retired)
        8 years ago
        dasabaja wrote:

        One final question: is there a way to iterate through all the variables in a Word file? I have that function that itterates in VBA, but obviously TC script and VBA are not the same...

        Use a for loop from 1 to Variables.Count and access the variables using Variables.Item(index):

        for (var i = 1; i <= WordDoc.Variables.Count; i++)
{
  variable = WordDoc.Variables.Item(i);
  Log.Message(variable.Name + ": " + variable.Value);
}

        Keep in mind that MS Office indexing is 1-based, not 0-based.

  • Manfred_F's avatar
    Manfred_F
    Regular Contributor
    8 years ago

    You've got a word Automation Problem.

    A variable can not be accessed by Name.

    You have to iterate the variables and check for the given Name to get Access to Your variable.

    • dasabaja's avatar
      dasabaja
      Occasional Contributor
      8 years ago

      I have a piece of VBA code that iterates through all the variables in a document and prints them.

      I use it to check if I've placed all the variables into my Word document. 

       

      Private Sub ListAllVariables()
    Dim myVariable As Variable
    
    For Each myVariable In ThisDocument.Variables
        Debug.Print myVariable.Name & " : " & myVariable.Value
    Next
End Sub

      How can I implement this in my TC function? 

       

      I know how to iterate through arrays and stuff in Javascript, but how can I iterate something I don't have access to?