[AccessD] Access plus Excel question

Arthur Fuller fuller.artful at gmail.com
Thu Sep 9 13:23:29 CDT 2021


Thanks, Rocky. In the past, I have done quite a bit with Excel 's version
of VBA. I've just never tried it from Access; But this is a good place to
start.

On Thu, Sep 9, 2021 at 2:13 PM Rocky Smolin <rockysmolin2 at gmail.com> wrote:

> Arthur:
>
> 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.
>
> r
>
> On Thu, Sep 9, 2021 at 10:30 AM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur


More information about the AccessD mailing list