![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks. |
| |||||||
![]() |
| |
| | #1 (permalink) |
| | excel & WSH question Hello, I have a question about excel and WSH. Here is the code I am using, Dim xapp Dim xbook set xapp = WScript.CreateObject("Excel.Application") xapp.WorkBooks.Open "xxx..." xapp.visible = true set xbook = xapp.activeworkbook.worksheets("yyy...") xbook.activate My problem is the following: normally when I open excel, I have additional custom worksheet functions available through certain add-ins (namely, Bloomberg). However, when I open the workbook with the WSH script, those additional worksheet functions do not seem to load automatically, and the custom worksheet functions are not recognized (they return #NAME?). Is there an additional option I need to specifiy to get this to work? Any help appreciated! Thanks! Kris |
My System Specs![]() |
![]() |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Forum | |||
| Excel 2003 VB Scripting Question. How to change row color whenclicking a clickable | VB Script | |||
| create Excel spreadsheet without loading Excel | VB Script | |||
| Question about Copy() method in Excel | PowerShell | |||
| How to view Excel document without Microsoft Office Excel installe | Vista General | |||
| Vista ASP.NET 2.0 Cannot open Excel File using Microsoft.Excel 12.0 COM object | Microsoft Office | |||