[AccessD] Access plus Excel question

[Arthur Fuller]

Fortunately it's a small operation, consisting of David and his wife (and
me, when needed). It's a very specialized business. Without prior exposure
to the business environment, it would take a developer weeks or months to
learn the terminology. We haave occasionally discussed finding developers
in the US to partner with, but so far have not done so.

In Access, I use static functions a lot. Is it possible to call an Access
static function from Excel?

On Thu, Sep 9, 2021 at 4:15 PM James Button via AccessD <
accessd at databaseadvisors.com> wrote:

> And  I thought a bit about the using "365", and realised:
>
> Firstly, you didn't mention what version of 365 will be the lowest common
> denominator.
> Will that imply that the "home" 2016 and 2019 (and maybe 2010) versions
> will be
> acceptable versions for the target systems to be running.
>
> Or is the cloud involved - NO VBA MACROS, but maybe Add-In's, or the new
> scripting ?
> and if the cloud is involved - Onedrive being the possible storage
> location for
> files?
> Or is this purely on your system ?
> and is that a corporate/server type environment?
>
> Considerations to be made as to limitations in the processing, and maybe
> file
> access security imposed, as well as protecting your work from abstraction
> and/or
> modification.
> but I presume you have that in hand.
> There are some on the lists with lots of understanding of the glitches
> associated with those situations.
>
> JimB
>
>
>
> -----Original Message-----
> From: AccessD
> <accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On
> Behalf Of
> John Colby
> Sent: Thursday, September 9, 2021 8:58 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] Access plus Excel question
>
> 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>
> 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
> >
>
>
> --
> John W. Colby
> Colby Consulting
> --
> 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