NLGroup
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also see links at: http://www.google.com/search?hl=en&q=ms+access+workday+function&btnG=Google+Search