Problem home-made modules in Access and PivotTables in Excel

[JB83]

Dear reader(s),

I have a problem with Access 2000 / Excel 2000. When I create a PivotTable for a database (which is created in Access 2000), it gives the following error when I select my tables to put into the PivotTable:
"Undefined function 'nameOfFunction' in expression". I have made a module in Access myself, but it cannot be read by Microsoft Query. Is there a possiblity to solve this problem?

Thanks in advance,

Jochen. --------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.

 

[MichaelRed]

Your explination is not so clear to me. I am thinking you are attempting to refer to the module you have created in Ms. A. from Excel? And you are creating some table in Ms. A. (result of make table from a cross-tab query?) and manipulating this from excel using a "PiviotTable" function which is relying on the module you created in Ms. A?

Please clarify?

I would not understand the convoloutions of this, -even if just mostly correct- as it seems (appears) that all necessary processes and procedures are available in Ms. A. and the use of Excel is just burdensome.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[JB83]

Michael,

I have done the following: at first I have created a module within Access to calculate the workdays (without holidays and weekends) because there isn't any function which can calculate this (Excel has a function called Networkdays, but it cannot be used in Access). When I want to create a PivotTable in Excel of the data from Access, I get the following error (from Microsoft Query): "Undefined function 'dhCountWorkdaysA' in expression." after selecting the table I want to add for the PivotTable. This function is the function I created in Access.

I hope this clarifies enough,

Jochen.

--------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.

 

[MichaelRed]

Can't you 'create' the piviot table in Ms. A. and export the result to Excel?

What is 'necessaryily' done in Excel which cannot also be done in Ms. A.

Why can't you 'port' the function to Ms. E.? VBA for the two share the core VB, it is only app specific items which are different.

There is (see faq181-261) a Ms. A. function which does calculate wroking days. With little effort, I'm sure it can be used in Ms. E.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[JB83]

Michael,

I have already used a comparable function of this FAQ in MS Access which is called dhCountWorkdaysA. I have renamed the function to Networkdays to see if Excel would get it, but Excel didn't.
You mentioned a port to Excel: Is there a possibility to port this function in Excel?

Jochen. --------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.