[AccessD] Access plus Excel question

[James Button]

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