I am writing a macro and need to calculate the workdays between 2 columns
that have dates. I see that in Excel there is a function called NETWORKDAYS
but when I use this in the macro it tells me that this is not defined. Help
- is there some addin that I need to add to my microsoft Visual basic macro
feature to use this function?

Hi AC,

In the VBE, add a reference to the analysis toolpak VBA:

Tools | check 'APTVBAEN.XLS'


---
Regards,
Norman



"AC" wrote in message
...
I am writing a macro and need to calculate the workdays between 2 columns
that have dates. I see that in Excel there is a function called
NETWORKDAYS
but when I use this in the macro it tells me that this is not defined.
Help
- is there some addin that I need to add to my microsoft Visual basic
macro
feature to use this function?

Hi AC,

Tools | check 'APTVBAEN.XLS'

Should read:

Tools References | Check 'APTBAEN.XLS'

---
Regards,
Norman


"Norman Jones" wrote in message
...
Hi AC,

In the VBE, add a reference to the analysis toolpak VBA:

Tools | check 'APTVBAEN.XLS'


---
Regards,
Norman

I just went to my VBE Tools REferences to see if I had this loaded, and I
didn't see it.
I went to reg Excel and did Tools, Add-Ins
Saw "Analysis-Tool-Pak-VBA << Unchecked
so I checked it and OK'd out.
I closed Excel totally, and reloaded.

Then I went back to VBE - Tools References, and there
saw atpvbaen.xls listed, but unchecked.. so I checked it.
and Ok'd out.
So the file name is:

ATPVBAEN.xls

Last thing (with question) - Now even though the ToolsPak-VBA box is checked
IN BOTH REG EXCEL
AND VBE-Tools REf, when I highlight it (in either window) and click on the
browse button I'm taken to a Folder without the atpvbaen appearing

Independently, in Explorer I can find the atpvbaen.xla file in:
C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis

I must guess that mysteriously I'm "hooked-Up" somehow////???


"Norman Jones" wrote in message
...
Hi AC,

Tools | check 'APTVBAEN.XLS'

Should read:

Tools References | Check 'APTBAEN.XLS'

---
Regards,
Norman


"Norman Jones" wrote in message
...
Hi AC,

In the VBE, add a reference to the analysis toolpak VBA:

Tools | check 'APTVBAEN.XLS'


---
Regards,
Norman

Also now when I close and re-enter my VBE environmnet my immediate window
contains:

[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs]
[PickPlatform] <
[PickPlatform]
[VerifyOpen] <
[VerifyOpen] 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs]
[auto_open]

How can I Clean-this-up, where it
no longer appears?



"Jim May" wrote in message
news:Qpm8f.5353$mV4.3576@dukeread02...
I just went to my VBE Tools REferences to see if I had this loaded, and I
didn't see it.
I went to reg Excel and did Tools, Add-Ins
Saw "Analysis-Tool-Pak-VBA << Unchecked
so I checked it and OK'd out.
I closed Excel totally, and reloaded.

Then I went back to VBE - Tools References, and there
saw atpvbaen.xls listed, but unchecked.. so I checked it.
and Ok'd out.
So the file name is:

ATPVBAEN.xls

Last thing (with question) - Now even though the ToolsPak-VBA box is
checked IN BOTH REG EXCEL
AND VBE-Tools REf, when I highlight it (in either window) and click on the
browse button I'm taken to a Folder without the atpvbaen appearing

Independently, in Explorer I can find the atpvbaen.xla file in:
C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis

I must guess that mysteriously I'm "hooked-Up" somehow////???


"Norman Jones" wrote in message
...
Hi AC,

Tools | check 'APTVBAEN.XLS'

Should read:

Tools References | Check 'APTBAEN.XLS'

---
Regards,
Norman


"Norman Jones" wrote in message
...
Hi AC,

In the VBE, add a reference to the analysis toolpak VBA:

Tools | check 'APTVBAEN.XLS'


---
Regards,
Norman

Hi Jim,

So the file name is:

ATPVBAEN.xls

Indeed: A(nalysis) T(ool) P(ak) VBA EN(glish)

A touch of momentary dyslexia on my part!

As to the immediate window entries, those would appear to be benign and the
result of a setup report which MS have failed tp expunge in your version - I
may be mistaken, but did you not recentlty install xl2003?

I do not use xl2003, at least not here, and I have not had your experience.
Others will, therefore, be better able to comment.


---
ards,
Norman



"Jim May" wrote in message
news:Qum8f.5356$mV4.1068@dukeread02...
Also now when I close and re-enter my VBE environmnet my immediate window
contains:

[auto_open] <
[SetupFunctionIDs] <
[SetupFunctionIDs]
[PickPlatform] <
[PickPlatform]
[VerifyOpen] <
[VerifyOpen] 1
[RegisterFunctionIDs] <
[RegisterFunctionIDs]
[auto_open]

How can I Clean-this-up, where it
no longer appears?



"Jim May" wrote in message
news:Qpm8f.5353$mV4.3576@dukeread02...
I just went to my VBE Tools REferences to see if I had this loaded, and I
didn't see it.
I went to reg Excel and did Tools, Add-Ins
Saw "Analysis-Tool-Pak-VBA << Unchecked
so I checked it and OK'd out.
I closed Excel totally, and reloaded.

Then I went back to VBE - Tools References, and there
saw atpvbaen.xls listed, but unchecked.. so I checked it.
and Ok'd out.
So the file name is:

ATPVBAEN.xls

Last thing (with question) - Now even though the ToolsPak-VBA box is
checked IN BOTH REG EXCEL
AND VBE-Tools REf, when I highlight it (in either window) and click on
the browse button I'm taken to a Folder without the atpvbaen appearing

Independently, in Explorer I can find the atpvbaen.xla file in:
C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis

I must guess that mysteriously I'm "hooked-Up" somehow////???


"Norman Jones" wrote in message
...
Hi AC,

Tools | check 'APTVBAEN.XLS'

Should read:

Tools References | Check 'APTBAEN.XLS'

---
Regards,
Norman


"Norman Jones" wrote in message
...
Hi AC,

In the VBE, add a reference to the analysis toolpak VBA:

Tools | check 'APTVBAEN.XLS'


---
Regards,
Norman

Hi Jim,

There is an ATP addin for Excel and another addin (ATPVBAEN) for VBA.

If you look at the addin list in Excel, you should see both.

---
Regards,
Norman



"Jim May" wrote in message
news:Qpm8f.5353$mV4.3576@dukeread02...
I just went to my VBE Tools REferences to see if I had this loaded, and I
didn't see it.
I went to reg Excel and did Tools, Add-Ins
Saw "Analysis-Tool-Pak-VBA << Unchecked
so I checked it and OK'd out.
I closed Excel totally, and reloaded.

Then I went back to VBE - Tools References, and there
saw atpvbaen.xls listed, but unchecked.. so I checked it.
and Ok'd out.
So the file name is:

ATPVBAEN.xls

Last thing (with question) - Now even though the ToolsPak-VBA box is
checked IN BOTH REG EXCEL
AND VBE-Tools REf, when I highlight it (in either window) and click on the
browse button I'm taken to a Folder without the atpvbaen appearing

Independently, in Explorer I can find the atpvbaen.xla file in:
C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis

I must guess that mysteriously I'm "hooked-Up" somehow////???


"Norman Jones" wrote in message
...
Hi AC,

Tools | check 'APTVBAEN.XLS'

Should read:

Tools References | Check 'APTBAEN.XLS'

---
Regards,
Norman


"Norman Jones" wrote in message
...
Hi AC,

In the VBE, add a reference to the analysis toolpak VBA:

Tools | check 'APTVBAEN.XLS'


---
Regards,
Norman