Re: exporting from access to excel in a template

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Jenn,

There's no easy way. One technique - which works within quite severe
limitations - is described at
http://alexdyb.blogspot.com/2006_07_01_alexdyb_archive.html
under the heading "Export to Excel range".

If that doesn't fill the bill, it's necessary to write VBA code that
automates Excel, either exporting in the usual manner and then
formatting the resulting workbook or else creating a new workbook from
the template and placing the data into the relevant cells.

On Fri, 12 Jan 2007 08:19:02 -0800, Jenn
<Jenn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Is there any way to export data from access to excel into a already created
template?

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

Relevant Pages

  • Re: Changed Excel 2003 startup now wont save to default location
    ... "Dave Peterson" wrote: ... is there any way to have this template be the startup template so when ... Sounds like she is just using an *.xls workbook as her start point. ... You must save as>file type>ms excel template ...
    (microsoft.public.excel.misc)
  • Re: How to close XLAs, but not Excel...
    ... The recommended method is to use workbook and worksheet object references: ... The Excel Calculation Site ... , stored on the network, as a template for creating a file ... nearly had to abandon it - enter XLA files. ...
    (microsoft.public.excel.programming)
  • Re: Changed Excel 2003 startup now wont save to default location
    ... "Dave Peterson" wrote: ... is there any way to have this template be the startup template so when ... Sounds like she is just using an *.xls workbook as her start point. ... You must save as>file type>ms excel template ...
    (microsoft.public.excel.misc)
  • Re: Changed Excel 2003 startup now wont save to default location
    ... "Dave Peterson" wrote: ... is there any way to have this template be the startup template so when ... Sounds like she is just using an *.xls workbook as her start point. ... You must save as>file type>ms excel template ...
    (microsoft.public.excel.misc)
  • Re: Changed Excel 2003 startup now wont save to default location
    ... "Dave Peterson" wrote: ... is there any way to have this template be the startup template so when ... Sounds like she is just using an *.xls workbook as her start point. ... You must save as>file type>ms excel template ...
    (microsoft.public.excel.misc)