Passing Arguments to VBA Procudures

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Passing Arguments to VBA Procudures

Logged in as: Guest

arrSession:exec spGetSession 2,2,698

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Passing Arguments to VBA Procudures
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Passing Arguments to VBA Procudures - 10/7/2002 4:41:58 PM

marcuscus

Posts: 1
Score: 0
Joined: 10/7/2002
From: United Kingdom
Status: offline

Hi all,

This may be a daft question (I'm begineer) but is it possible to pass variables to a VBA procedure from a VBScript?

For example...

Dim name
Dim excel
Set excel = CreateObject("Excel.Application")
excel.Visible = True
excel.Workbooks.Open( "E:\test.xls" )
name = "Marco"
Call excel.Run( "test.xls!PrintName", name )

Where the VBA function is...

Sub PrintName( name As String )
MsgBox name
End Sub

Thanks for any help,
Marco