|
-
October 29th, 1999, 03:22 AM
#1
Filling an Excel Page
I've got a program that exports cell by cell from a MSFlexGrid to an excel worksheet, using the code:
With MSFViewer
for mRow = 0 to .Rows - 1
for mcol = 0 to .Cols - 1
mXcol = Chr(65 + mcol)
mExcel.Application.ActiveWorkbook.Worksheets.Application.ActiveCell(mRow + 1, mXcol) = .TextMatrix(mRow, mcol)
next
next
End With
This works fine but is very slow.
Is there a way of cutting and pasting the whole grid directly into excel?
Thanks
James
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|