Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MSFlexGrid to EXCEL....
- Thread starter aliinal
- Start date
edderic
Programmer
- May 8, 1999
- 628
Private Sub cmdExcel_Click()
Dim iRow As Integer, iCol As Integer
With Grid
iRow = .Row: iCol = .Col
.Row = 0: .Col = 0
.RowSel = .Rows - 1: .ColSel = .Cols - 1
Clipboard.SetText .Clip
.Row = iRow: .Col = iCol
End With
Dim xlAppl As Excel.Application
Set xlAppl = New Excel.Application
With xlAppl
.Visible = True
.Workbooks.Add
.ActiveSheet.Paste
End With
End Sub
Eric De Decker
vbg.be@vbgroup.nl
Dim iRow As Integer, iCol As Integer
With Grid
iRow = .Row: iCol = .Col
.Row = 0: .Col = 0
.RowSel = .Rows - 1: .ColSel = .Cols - 1
Clipboard.SetText .Clip
.Row = iRow: .Col = iCol
End With
Dim xlAppl As Excel.Application
Set xlAppl = New Excel.Application
With xlAppl
.Visible = True
.Workbooks.Add
.ActiveSheet.Paste
End With
End Sub
Eric De Decker
vbg.be@vbgroup.nl
- Thread starter
- #3
It is always useful to tell the line that gives you the error...
My guess is that you didn't include the Excel object library into your project.
Go to the Project Menu, Select References at the bottom of this menu and when they show up check the box for Microsoft Excel xx Object Library _________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]
My guess is that you didn't include the Excel object library into your project.
Go to the Project Menu, Select References at the bottom of this menu and when they show up check the box for Microsoft Excel xx Object Library _________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]
- Thread starter
- #5
- Thread starter
- #6
Hi.
You should try making a for---next to capture the data on your grid (and then pass it to variables or hidden text boxes) and then send it to Excel.
For nCounter = 1 to MSFlexGrid.Rows
MSFlexGrid.col = 1
x = MSFlexGrid.Text
-----
-----
Then send it to Excel...
Next
Search the Microsoft CD for a file called Vbaxl8.hlp (or something close). You'll find all you need to know.
Have fun!!!
You should try making a for---next to capture the data on your grid (and then pass it to variables or hidden text boxes) and then send it to Excel.
For nCounter = 1 to MSFlexGrid.Rows
MSFlexGrid.col = 1
x = MSFlexGrid.Text
-----
-----
Then send it to Excel...
Next
Search the Microsoft CD for a file called Vbaxl8.hlp (or something close). You'll find all you need to know.
Have fun!!!
- Thread starter
- #8
By dzidze's advice, i tried to send all data to excel cell-by-cell
a simple for loop for columns, and one for rows inside it. And set excel's cell's all properties to flexgrids properties. like
excel.range(cells(i,j),(cells(i,j)).interior.color = msflexgrid.cellbackgroundcolor
and many lines for all other properties like fontbold italic etc.etc.
this seems to work but its very very slow even on a 860 Mhz Pentium III.
But i'm writing this program for a P75
can anyone advice me a faster way???
a simple for loop for columns, and one for rows inside it. And set excel's cell's all properties to flexgrids properties. like
excel.range(cells(i,j),(cells(i,j)).interior.color = msflexgrid.cellbackgroundcolor
and many lines for all other properties like fontbold italic etc.etc.
this seems to work but its very very slow even on a 860 Mhz Pentium III.
But i'm writing this program for a P75
can anyone advice me a faster way???
- Thread starter
- #9
Hi aliinal.
I'm having the same problem with a similar project. The coding ain't that big, but it's true that it does seem to take some time. And I'm working on a P3-900.
If I ever find anything to make it faster I'll let you know.
Of course, if anybody has a solution, they can post it so we can see it...
I'm having the same problem with a similar project. The coding ain't that big, but it's true that it does seem to take some time. And I'm working on a P3-900.
If I ever find anything to make it faster I'll let you know.
Of course, if anybody has a solution, they can post it so we can see it...
- Status
Similar threads
