Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Assign variables to specific paramters in function calls

Status
Not open for further replies.

JTBorton

Technical User
Jun 9, 2008
345
DE
Quick question - I'm used to mainly coding in VBA for Excel and I like to assign variables to specific parameters when I make function calls (the ':=' ), such as:

Code:
     MsgBox Prompt[highlight]:=[/highlight]strMsg, Buttons[highlight]:=[/highlight]lngButtons, Title[highlight]:=[/highlight]strProgramTitle

Just my own personal discipline I guess. Well I'm trying to whip out a quick vbscript to copy an excel add-in file and auto-install it into excel for my less technically inclined users. I'm getting an error when I try to make this specific assignment using the ':='. Can you even do this in vbscript or is there another way to speicify parameters?

-Joshua
If it's not broken, it doesn't have enough parts yet.
 
There is NO named parameter in VBS, dot.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top