Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
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.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - excel & WSH question

Reply
 
Old 02-26-2009   #1 (permalink)
Kris


 
 

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 SpecsSystem Spec
Reply

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


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46