🚀 go-pugleaf

I'm placing text into a table cell via Visual Basic and would like to change the paragraph style at the same time but can not figure it out. Any suggestions?

      Public myInDesign As InDesign.Application Public myDocument As InDesign.Document
      Public myTable As InDesign.Table
      Sub put_data_in_table()
      Set myInDesign = CreateObject("InDesign.Application.2.0")
      Set myDocument = myInDesign.Open("C:\Template.indd")
      Rem I have a text frame built to hold my new table so I can modify the
      table to fit the frame
      Set myholdingart = myDocument.TextFrames.Item("Markets_and_Submarkets_Box")
      Set myTable = myholdingart.ParentStory.Tables.Add
      Set myTable = myTable.Parent.ApplyStyle("Mehtodology Text")
      myTable.ColumnCount = 2
      myTable.Columns.Item(1).Width = "2 in"
      myTable.Columns.Item(2).Width = "4.75 in"
      Set myinsertionpoint = myTable.Rows.Item(1).Cells.Item(1).InsertionPoints.Item(-1)
      REM --------- this style line doesn't work
      myinsertionpoint.ApplyStyle = myDocument.ParaStyles.Item("footer")
      REM --------- end bad code
      myinsertionpoint.TextContents = "Some random copy in this cell"
      End Sub





Thanks in advance,
iolaire