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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dumping a datagrid in Excel
Hi, anyone out there who knows how to dump an entire(filled) datagrid from somewhere in my app into Excel? Need to control these: -use an existing sheet to send to -have control over where (which cells) to send the data to James aka Rossifumi- rossifumi
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
Create comma-delimited file using Access Database
This is how to set it up: Dim cn As New adodb.Connection Dim rst As New adodb.Recordset Dim sSql As String Dim strA As String Dim fso As New Scripting.FileSystemObject Dim txtFile As Scripting.TextStream With cn .ConnectionString = mksConnectionString .Open End With sSql =...- rossifumi
- Post #2
- Forum: Visual Basic (Classic)
-
Error Adding record to database
Dim cn As adodb.Connection Dim rs As adodb.Recordset Set cn = New adodb.Connection cn.ConnectionString = your connection string cn.Open Set rs = New adodb.Recordset rs.CursorType = adOpenKeyset rs.LockType = adLockOptimistic rs.Source = "your table" rs.ActiveConnection = cn rs.Open...- rossifumi
- Post #9
- Forum: Visual Basic (Classic)
-
Datagrid printing
Hi all, my project is coming to an end, but it seems that the last part is the hardest. Part of my application displays data in a datagrid, using an SQL qry. I am creating a document in Word, using data from my app. I also need to get the datagrid, or the data in the grid to that document. If...- rossifumi
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
