Mark H
Lists at theopg.com
Tue Jul 15 15:34:52 CDT 2003
You can also convert access macros to vba automatically - Tools - Macros - Convert Macros to VB (XP menus - can't remember 97 but it was possible there too) mark -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: 15 July 2003 21:21 To: 'Access Developers discussion and problem solving' Subject: Macros Was: RE: [AccessD] Using Excel from Access I think you have the macro stuff confused again, I seem to a remember a really long thread about macros outside of Access. I think what they are talking about is recording macros in Excel, Word, etc, to see what code is produced by the macros. However, I personally learned VBA in Access from macros. I had an application that was just chalk full of macros, and then ran into something that I couldn't do with a macro. (Hiding the Access window). Once I figured out how to get the 'magical' VBA code to work, I set about converting all of my macros to code. It was a wonderful learning process, and it actually is the reason I do what I do now, instead of working on pumps, valves, etc. <grin> It didn't take me long to realize that macros were crap, but sometimes you have to crawl before you can walk, so I would never say anything to a beginning developer about macros, other then try to help them when they want to move to code. Drew -----Original Message----- From: Arthur Fuller [mailto:artful at rogers.com] Sent: Tuesday, July 15, 2003 2:33 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Using Excel from Access 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 _______________________________________________ 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