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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by earthsci

  1. earthsci

    DAO to ADO Export to Excel

    Thanks for the example and link - I was not to clear on ADOX, but example made sense and I will try it
  2. earthsci

    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...
  3. earthsci

    Making a multipage report with Excel Macro

    Yes, I am writing two chunks of data consisting of 19 lines each to each page. Each page is 57 lines long. I had not tried it using the modulus, but I did get it to work finally. Your solution is much cleaner than what I came up with (as you can see) so I will probably switch to a check using...
  4. earthsci

    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...
See more

Part and Inventory Search

Back
Top