![]() |
![]() | ![]() | ![]() | ![]() | ![]() | ![]() | ![]() |
| 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) |
| | 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 Specs![]() |
![]() |
| 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 | |||