October 29th, 1999, 05:19 AM
Ok, I've changed my code from my earlier post to use the .clip property:
With MSFViewer
.Row = 0
.Col = 0
.RowSel = (.Rows - 1)
.ColSel = (.Cols - 1)
mExcel.Application.ActiveWorkbook.Worksheets.Application.ActiveCell(1, 1) = .Clip
End With
but this displays all the info in one cell
Any suggestions on how to expand this to one entry - one cell?
Thanks again
James
With MSFViewer
.Row = 0
.Col = 0
.RowSel = (.Rows - 1)
.ColSel = (.Cols - 1)
mExcel.Application.ActiveWorkbook.Worksheets.Application.ActiveCell(1, 1) = .Clip
End With
but this displays all the info in one cell
Any suggestions on how to expand this to one entry - one cell?
Thanks again
James