L
lylahk
I'm wanting to export an access query into an excel format
template. Is this possible??
Please make my life easier!!
Lylahk
template. Is this possible??
Please make my life easier!!
Lylahk
R
Russ
If anyone could provide a solution to this problem below,
I have a similar issue and would appreciate some
assistance. If there is not a reasonably efficient way to
export to an excel template, is there a way to better
control the export format without writing a week's worth
of code? The limited formatting that one can do in the
datasheet/recordset view is insufficient.
I will rework all of my Excel macros, if required, but it
seems like there should be a better way.
TIA,
Russ
I have a similar issue and would appreciate some
assistance. If there is not a reasonably efficient way to
export to an excel template, is there a way to better
control the export format without writing a week's worth
of code? The limited formatting that one can do in the
datasheet/recordset view is insufficient.
I will rework all of my Excel macros, if required, but it
seems like there should be a better way.
TIA,
Russ
J
John Nurick
Hi Lylahk,
It doesn't seem to be possible to do this using the standard export or
"analyze it" routines. Instead, you need to use Automation to create a
workbook from the Excel template and insert the data from the query. The
following links should help you get started.
Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm
Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859
ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148
ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476
There's also a white paper and code samples including tutorials
available from Microsoft at
http://support.microsoft.com/?id=253235
Also, search www.mvps.org/access
It doesn't seem to be possible to do this using the standard export or
"analyze it" routines. Instead, you need to use Automation to create a
workbook from the Excel template and insert the data from the query. The
following links should help you get started.
Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm
Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859
ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148
ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476
There's also a white paper and code samples including tutorials
available from Microsoft at
http://support.microsoft.com/?id=253235
Also, search www.mvps.org/access