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 - Call sub in Excel ThisWorkbook module from VBS

Reply
 
Old 02-05-2009   #1 (permalink)
XP


 
 

Call sub in Excel ThisWorkbook module from VBS

I'm trying to execute a sub residing in an Excel workbook,
in the "ThisWorkbook" module, but the VBS file fails to
see the function "ConvertFormNumber". The following
is an example of my current code:

Set oXL = CreateObject("Excel.Application")
Set oBK = oXL.Workbooks.Add(argFullName)
oXL.Visible = True
oBK.Application.Run "ConvertFormNumber"

Can someone please correct my code above or
otherwise show an example of how to execute/call
a subroutine residing in the "ThisWorkbook" module
from a VBS file?

Thanks much in advance.

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
running Excel Macro in in specified Excel files in spe PowerShell
create Excel spreadsheet without loading Excel VB Script
Call function with parameters that also call functions (.Net and P 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