[AccessD] Using Excel from Access

Hey David,

the magic word being "selection.formula".

Thanks so much for the jump start. Exactly the same advice (study macros) I
give to beginning Access programmers. Need to heed it myself.

Best,

Bob

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of David Emerson
Sent: Monday, July 14, 2003 9:10 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Using Excel from Access


At 14/07/2003, you wrote:
>Hey to the group,
>
>I am working with a new client. they asked me to provide a front end to
some
>Excel sheets. I told them it should not be too difficult. Of course I asked
>them why the whole project could not be moved to Access and was told "the
>CFO is very comfortable w/Excel", a common response according to
discussions
>at our local Access group breakfasts. They did agree that once I completed
>the project, they would not change anything in the sheets (oh yeah!).
>Well most of it is just a matter of linking to the sheet and treating like
a
>table. But one of the tasks is to recreate a viewable/printable version of
>one of the sheets and not let the user see the calcs behind any of the
>cells.
>
>Now for the question:
>Can I get a hold of the calculation/formula behind a given cell in a sheet
>thru automation?
>
>Once that is accomplished, I think I can supply a solution for them.
>
>TIA,
>
>Bob Heygood

Bob,

In Excel, start recording a macro, then select a cell with a calculation,
copy, then paste special and select the Values option.  Now stop recording
the macro and go and see what was recorded.  This will show you the
commands you need to automate the task.


Regards

David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (04) 478-7456

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com