[dba-Tech] Refer to an Excel formula

Jim Lawrence accessd at shaw.ca
Fri Aug 10 10:06:36 CDT 2007


Hi Arthur:

Would you not just go into Tools > Macro > Visual Basic Editor create any
function and then call that function from the cell?

Jim

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, August 10, 2007 7:22 AM
To: Discussion of Hardware and Software issues
Subject: [dba-Tech] Refer to an Excel formula

I want to grab a formula from an Excel cell and then parse it. What's the
syntax to grab the formula as text so I can then extract part of it using
the standard text functions?

TIA,
Arthur
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com




More information about the dba-Tech mailing list