Macros Was: RE: [AccessD] Using Excel from Access

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



More information about the AccessD mailing list