troubleshooting Question

Insert Formulas into an Excel Column from ms Access 2007.

Avatar of bcreen
bcreenFlag for United States of America asked on
Office ProductivityMicrosoft AccessMicrosoft Development
1 Comment1 Solution741 ViewsLast Modified:
I'm using Access 2007 vba to manipulate an Excel spreadsheet.  Column A contains a column header: "Dates" and the rest of the column contains dates up to the first empty cell in that column.

I need to iterate from A2 thru the last date and - based on the date - place one of two formulas into column "N" of the same row.   If date is before 1/1/2004 I put one formula, else I use a different formula.

Can someone give me a  rough algorithm with the appropriate row/cell/range related functions to accomplish this?  I have code to determine the STRINGS that represent the formulas relative to the rows they will be placed into.

I'm referencing the Excel Object Library and already have quite a a bit of working code which manipulates, formats, inserts columns, sorts, etc, etc, so I'm not totally inexperienced.  Just need some hints :-)   Thanks!

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros