networkdays error and vb

greglange · Mar 15th, 2002, 12:34 PM

When I open an excel file using vb code through MS access, the networkdays function in my spreadsheet gives me an error (#value). When I open the same file by opening excel from the start menu and then opening the file the networkdays returns the correct value. Any suggestions?
Thanks for your help

Anne Troy · Mar 15th, 2002, 01:44 PM

A little birdie told me that if you have BOTH the analysis toolpak AND the analysis toolpak for VBA loading as add-ins, this could cause the problem. Apparently, networkdays will run as a worksheet function with the analysis toolpak running, but if the VBA one is running, it will try to use code, which is (I'm told) not desireable for your use.

greglange · Mar 25th, 2002, 02:21 PM

So how do I get around this problem? Does anyone have any vb script that can get me around this problem, or can I turn on and off the add-ins when I need them?

Mar 15th, 2002, 01:44 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	A little birdie told me that if you have BOTH the analysis toolpak AND the analysis toolpak for VBA loading as add-ins, this could cause the problem. Apparently, networkdays will run as a worksheet function with the analysis toolpak running, but if the VBA one is running, it will try to use code, which is (I'm told) not desireable for your use. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 15th, 2002, 12:34 PM	#1
greglange New Member Join Date: Mar 2002 Posts: 2	When I open an excel file using vb code through MS access, the networkdays function in my spreadsheet gives me an error (#value). When I open the same file by opening excel from the start menu and then opening the file the networkdays returns the correct value. Any suggestions? Thanks for your help

Mar 25th, 2002, 02:21 PM	#3
greglange New Member Join Date: Mar 2002 Posts: 2	So how do I get around this problem? Does anyone have any vb script that can get me around this problem, or can I turn on and off the add-ins when I need them?