Passing Data to Excell from Access 2002 and then passing the results back to access.

I need to add 5 work days to a pending out date.  Since Excell has a workday function  I'm thinking I could pass the dates (could be a column of them) fields to a spreadsheet which has workday function set.

Once the spreadsheets runs the function I'd like to take the new dates and update a table in Access.

I'm fairly new and access and I think I need to do this in a module just not sure if this is possible or if anyone has another suggestion to accomisph the same thing.

example:

Spreadsheet

daterec              number of dasy to increment              results new pending out date
03/03/2006                            5                                      03/10/2006



NLGroupAsked:
Who is Participating?
 
strungCommented:
Did you really want this post in the Macintosh Applications section? Access doesn't run on Macs. Suggest you repost to Databases: MS Access.
0
 
strungCommented:
You may be able to do this in Access directly -- see: http://www.candace-tripp.com/pages/access_downloads.aspx (search the page for "workday")

Also see links at:  http://www.google.com/search?hl=en&q=ms+access+workday+function&btnG=Google+Search
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.