Avatar of bcreen
bcreenFlag for United States of America

asked on 

Insert Formulas into an Excel Column from ms Access 2007.

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!
Office ProductivityMicrosoft AccessMicrosoft Development

Avatar of undefined
Last Comment
harfang
ASKER CERTIFIED SOLUTION
Avatar of harfang
harfang
Flag of Switzerland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo