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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DAO to ADO Export to Excel
I am trying to convert some code in DAO to ADO in Access and I am having trouble with creating something similar to the CreateQueryDef command. Here is the code using DAO: Sub ExportExcel() Dim dbs As DAO.Database Dim qdf As DAO.QueryDef Dim rst As DAO.Recordset Dim sqlstr As String...- earthsci
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Making a multipage report with Excel Macro
Hello, I need to make a report using an Excel Macro that will write to a new page when the previous page is filled. I set up a For Loop to go through records in a dbf which will determine the number of pages to write out to. This is what I have written to test whether or not to go to the next...- earthsci
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
