Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Vbscript with Excel Add-in

Status
Not open for further replies.

bethd26

Programmer
Apr 23, 2009
2
How could I open an Excel worksheet with an Excel Add-in using Vbscript?

The Excel template is available but the formulas, f.e. the NETWORKDAYS are not working. It seems that the Analysis Toolpak is not loaded.
I am getting the error #NAME? in Excel.
It works fine with Excel 2007, where the Add-ins are loaded automaticaly but it does not work with Excel 2003 which is the version that I have to use.

 
The problem was solved. Thank you very much.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top