Hi there, I've had a bash at the coding and so far the below code works as a function.
What I'd like to be able to do, is to be able to enter the headings of the columns in access into the function thru a form. Is this possible working from code below?
Thanks.
Peter.
CODE STARTS HERE...
Hi there,
Yeah I'm not sure how to conenct to an ADO recordset. The code you sent before, is that ready to send queries and tables from Access into Excel?
Thanks.
What I'm after as major time saving tool is to be able to export queries and tables from Access, into Excel in specific sheets and specific cells.
Can anyone help me with a bit of code that does so!? Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.