evilmousse
Programmer
I need to docmd.outputto an ado recordset to excel. outputto-ing the report object is no good,
the texbox names are taken to be the column headers instead of the lables above them.
I use a naming convention, and txt_LoanNum above the data looks halfassed.
I'm making an adp, so dao won't work tho. I've already several solutions, most complex, but there's a fairly elegant solution at
Thing is, it uses a DAO recordset, and passes it via it's .name property. I've not found even how to pass an ADO recordset successfully, much less have the export succeed.
-g
PS. If anyone knows an iterative solution to this
where vba must go field-by-field, that's welcome too.
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
the texbox names are taken to be the column headers instead of the lables above them.
I use a naming convention, and txt_LoanNum above the data looks halfassed.
I'm making an adp, so dao won't work tho. I've already several solutions, most complex, but there's a fairly elegant solution at
Thing is, it uses a DAO recordset, and passes it via it's .name property. I've not found even how to pass an ADO recordset successfully, much less have the export succeed.
-g
PS. If anyone knows an iterative solution to this
where vba must go field-by-field, that's welcome too.
