print ADO recordset in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BillyRogers - 26 Sep 2006 17:10 GMT

Instead of Debug.Print rst.fields(0)
how can i open a new Excel workbook and print the field in the first cell?

Signature

Billy Rogers

Dallas,TX

Currently Using Office 2000 and Office 2003

Reply to this Message

pietlinden@hotmail.com - 26 Sep 2006 17:45 GMT

> Instead of Debug.Print rst.fields(0)
> how can i open a new Excel workbook and print the field in the first cell?
[quoted text clipped - 5 lines]
>
> Currently Using Office 2000 and Office 2003

this will do it.
http://www.mvps.org/access/modules/mdl0035.htm

Reply to this Message

Barry Gilbert - 26 Sep 2006 17:59 GMT

Try this:

Dim xlApp As New Excel.Application
xlApp.Workbooks.Add
xlApp.Workbooks(1).Worksheets(1).Range("A1") = rstFields(0)
xlApp.Visible = True

Barry

> Instead of Debug.Print rst.fields(0)
> how can i open a new Excel workbook and print the field in the first cell?

Reply to this Message