• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

Need to pass multiple parameters in VBA code

What would be the best way to pass multiple parameters in the string below? For example, var2, and var3

http://server/WebForm1.aspx?var1=" & strEnvelope
0
Member_2_7964962
Asked:
Member_2_7964962
1 Solution
 
Russ SuterCommented:
A query string will allow multiple parameters easily. Just separate them with the '&' character like this:

http://server/WebForm1.aspx?var1=" & strEnvelope & "&var2=" & strSomething & "&var3=" & strSomethingElse

Open in new window


VBA makes this parsing look a little ugly since it uses the same character for string concatenation. The end result URL should look something like:

http://server/WebForm1.aspx?var1=value1&var2=value2&var3=value3

Open in new window

0
 
Member_2_7964962Author Commented:
Thank you.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now