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
Thanks for your help