Arthur Fuller
artful at rogers.com
Tue Jul 15 14:32:57 CDT 2003
Really? You actually give that advice (study macros) to beginning Access programmers? When I see beginning programmers using macros, I slap them silly! :-) Well, not really. I just point out that they are impossible to error-trap. A. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bob Heygood Sent: July 15, 2003 1:03 AM To: Access Developers discussion and problem solving Subject: RE: [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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com