[AccessD] Access plus Excel question

Rocky Smolin rockysmolin2 at gmail.com
Thu Sep 9 13:12:38 CDT 2021


I discovered that ANYTHING you can do manually to an Excel Spreadsheet, you
can do PROGRAMMATICALLY with vba.

The problem is how to write the code for what you want to do.

The solution is to use the Excel macro recorder and then look at the code
it generated for the macro.  Copy it out and paste it into your Access code
and walla! You can do any kind of formatting, inserting, make formulas,
virtually all things EXCEL through vba.


On Thu, Sep 9, 2021 at 10:30 AM 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

More information about the AccessD mailing list