Importing Access into Excel... Won't Work With 'WorkdaysFunction

[willehahr]

Hi All,
I've tried to solve this problem for a few days (with Google and whatnot) and my friend suggested I try on here.

I'm currently grabbing data from SharePoint and running a few queries in Access. In the queries, I run some calculations to make the data more useful. One calculation I did was:

Please Login or Register  to view this content.

My boss said to use business days instead of regular days. I looked around and I found a function, called Workdays, on the Microsoft Website, and it works! Now the calculation looks like:

Please Login or Register  to view this content.

After performing queries in Access, I import it into Excel with PivotTables and whatnot. Unfortunately, when I try to import the data with this function it does not work. I suspect it may be a local/global thing. I've tried copying the function into an Excel Module to make sure that it would work, but it still does not work.

~~~~~~~~~Testing~~~~~~~~~~~~

I've tried...

• Getting rid of the Workdays function, and it exports into Excel without a problem!
• Copying and pasting the Workdays function into Excel VBA, and it still does not work.
• Importing from 'Microsoft Query' instead of From 'Access', it doesn't like the Workdays function.
• Writing blanks as 0's in the file to make sure.

Just to make sure, I've copied and pasted my Access code here. Workdays calls on Weekdays as a function, and also a Holidays table in Access.

Please Login or Register  to view this content.

[willehahr]

I found a solution:
You cannot import that function into Excel. I instead created the functions in Excel under "Options" --> "Formulas", and created them there.