Im writing some code in VB6 that uses word as a report generator.
I need at least 4 tables in the document but everytime I create a second table it nests in the first
I tried everyting I could think of or read on.
Can anyone help
Here's part of the code. Ive taken the cell ref's and text type out for brevity.
Thanks
Dan
Private Sub OPEN_MISS_WORD()
Set wrdapp = CreateObject("word.application"![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Set wrddoc = wrdapp.Documents.Add
Set wrdsel = wrdapp.Selection
wrdapp.Documents.Open ("C:\pst2.dot"![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
With wrdsel
.Tables.Add Range:=wrdsel.Range, NumRows:=3, NumColumns:=5, DefaultTableBehavior:=wdWord9TableBehavior, AutoFitBehavior:=wdAutoFitFixed
.Tables.Add Range:=wrdsel.Range, NumRows:=3, NumColumns:=5, DefaultTableBehavior:=wdWord9TableBehavior, AutoFitBehavior:=wdAutoFitFixed
End With
wrddoc.SaveAs ("c:\pst2.doc"![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
wrdapp.Quit
Set wrdsel = Nothing
Set wrddoc = Nothing
Set wrdapp = Nothing
DoEvents
If ShellExecute(0, "Open", "C:\pst2.doc", "", App.Path, SW_SHOWMAXIMIZED) < 33 Then
MsgBox "An error occured opening the file.", vbInformation, "Can't open File! It May be already open"
End If
DoEvents
Screen.MousePointer = vbDefault
End Sub
I need at least 4 tables in the document but everytime I create a second table it nests in the first
I tried everyting I could think of or read on.
Can anyone help
Here's part of the code. Ive taken the cell ref's and text type out for brevity.
Thanks
Dan
Private Sub OPEN_MISS_WORD()
Set wrdapp = CreateObject("word.application"
Set wrddoc = wrdapp.Documents.Add
Set wrdsel = wrdapp.Selection
wrdapp.Documents.Open ("C:\pst2.dot"
With wrdsel
.Tables.Add Range:=wrdsel.Range, NumRows:=3, NumColumns:=5, DefaultTableBehavior:=wdWord9TableBehavior, AutoFitBehavior:=wdAutoFitFixed
.Tables.Add Range:=wrdsel.Range, NumRows:=3, NumColumns:=5, DefaultTableBehavior:=wdWord9TableBehavior, AutoFitBehavior:=wdAutoFitFixed
End With
wrddoc.SaveAs ("c:\pst2.doc"
wrdapp.Quit
Set wrdsel = Nothing
Set wrddoc = Nothing
Set wrdapp = Nothing
DoEvents
If ShellExecute(0, "Open", "C:\pst2.doc", "", App.Path, SW_SHOWMAXIMIZED) < 33 Then
MsgBox "An error occured opening the file.", vbInformation, "Can't open File! It May be already open"
End If
DoEvents
Screen.MousePointer = vbDefault
End Sub