[AccessD] Access plus Excel question

John Colby jwcolby at gmail.com
Thu Sep 9 14:57:42 CDT 2021

You can do it any of those ways.  I tend to use a "template" spreadsheet
with all of the formatting already done.Then I copy that file to a new file
and push the data into it in named or plain old letter / number ranges.

On Thu, Sep 9, 2021 at 1:30 PM Arthur Fuller <fuller.artful at gmail.com>

> The Access app I'm working on invokes Excel and tis part works perfectly.
> Access builds up the XLS filename, complete with path, company, project and
> actual XLS filename -- smooth as silk.
> One problem remains. What Excel receives is the tabular data and nothing
> else. I want to include some header information above the grid in the XLS
> file, similar to what I do in the Access report to which the XLS file
> corresponds.
> A couple of things come to mind. Use an XL template with a few named
> ranges, then address those from Access once the XLS file is open, or
> reverse the process and have Excel call back to Access and have it return
> the data. (Access can make the three items of interest available using
> three static functions.) Another notion that occurred to me depends
> on whether I can pass parameters to Excel when I invoke it.
> Besides these, there are doubtless other approaches I might use to get
> there. Any suggestions?
> (If it matters, this is all being done in Office 365.)
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

John W. Colby
Colby Consulting

More information about the AccessD mailing list