CrunchMasterMatt
Board Regular
- Joined
- Jul 20, 2012
- Messages
- 123
Hi All, I'm trying to open a web address via VBA macro and also have a cells value copied into the clipboard memory, so once the user gets to the webpage, then can paste the data in the clipboard into a box in the webpage.
for example, say I want to open weather.gov and have in memory "92624" as a zipcode, how do I do this?
Thank You!!!!
PS Ive created a hyperlink and can open the webpage using it, but that ONLY executes the hyperlink - and doesnt run any code which would otherwise allow me to copy the zipcode first, before navigating via the hyperlink.
for example, say I want to open weather.gov and have in memory "92624" as a zipcode, how do I do this?
Thank You!!!!
PS Ive created a hyperlink and can open the webpage using it, but that ONLY executes the hyperlink - and doesnt run any code which would otherwise allow me to copy the zipcode first, before navigating via the hyperlink.