VBA Function

[BoredBloke]

OK I'm stumped on this.

2 PC's supposedly the same build.

Running a spreadsheet. Spreadsheet 1 has a vba function (public) to work out the number of working days when given a date. Spreadsheet 2 has a link to spreadsheet 1 (path included) which cannot find the workingdays function. If I open Spreadsheet 1 along with 2 it resolves the function.

However, one PC this works fine on, the other is giving the problem outlined above.

What am I missing? - I didn't write the code and wouldn't have done it in this way, but it is a pain that it only works on one of the PC's

 

[AtW]

There should be WORKDAY function in Analysis Tool Pak (plug ins).

 

[BoredBloke]

I know, but for some readson they decided to write their own. I'm guessing that they didn't know it was there.

 

[AtW]

Well, maybe its something simple like path on 2nd PC does not exist?

 

[MarillionFan]

Sounds like the function is in the second spreadsheet, which means you need to load it up first. Move the function to the Personal Macro Workbook on the machine instead.

 

[BoredBloke]

I have managed to track it to an account issue. My account it does not work with. However, a colleague can run the process using his account on my PC. His drive mappings are the same as mine.`