Linking a VBA button to Excel cell
Thanks will test this out this morning
"Stopher" wrote:
beginner here wrote:
Thanks for the additional help, but I'm stilling getting an error. This time
it is saying: Invalid procedure call or argument
So here is my present code with the changes:
Shell ("C:\Program Files\Adobe\" & Range("F4") & ".pdf")
Steve
Dim newpath as String, sStr as String
newpath = "C:\Program Files\Adobe\"
sStr = ("cmd /c " & newpath & Range("F4") &".pdf"
Call Shell(sStr, vbNormalFocus)
Stole this out of a post by Tom and adopted it for your instance.
|