Hyperlinks
 

Users key numbers into several unprotected cells the results of which are
concatenated else ware in a workbook. Those concatenated results need to be
transmitted internally. I can store the final result as a string. Manually
if I copy that string, paste special values else ware then click on that
hyperlink, that data shoots through and is stored in a polling app correctly.
If I have a users information in a variable, how do I override the manual
process as described and automate the transmission of data? Recording these
steps has not shed enough light

Example of string:
http://poll.ABC/poll/open/pollSubmit...l=109653&q1=Mr.
X&q2=A&q3=3&q4=828&q5=249&q6=249&q7=174&q8=0.695 52

Sincerely,
Arturo

Hyperlinks
 

Arturo

Put the string in a variable and use the FollowHyperlink method of the
Workbook object.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Arturo wrote:
Users key numbers into several unprotected cells the results of which
are concatenated else ware in a workbook. Those concatenated results
need to be transmitted internally. I can store the final result as a
string. Manually if I copy that string, paste special values else
ware then click on that hyperlink, that data shoots through and is
stored in a polling app correctly. If I have a user's information in
a variable, how do I override the manual process as described and
automate the transmission of data? Recording these steps has not
shed enough light

Example of string:
http://poll.ABC/poll/open/pollSubmit...l=109653&q1=Mr.
X&q2=A&q3=3&q4=828&q5=249&q6=249&q7=174&q8=0.695 52

Sincerely,
Arturo