Hello,
I'm looking to open a .pdf file with a Command button
The sheet name is Components and the .pdf is on cell A10
I have the button installed on the worksheet but not sure what comes next
I'm trying do something like this:
Crazy attempt!
Please Login or Register to view this content.
Doesnt work...
Rob
Last edited by jeffreybrown; 12-04-2018 at 07:11 PM. Reason: Code tags please!
Hi Rob,
As long as the full path (directory + filename) is in cell A10 of the Components sheet, this will work:
Regards,Please Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Hello Robert,
Thank you for your response.
I needed to change the worksheet around a little bit
Would it be possible to obtain the code to open the pdf on cell A10 in the same worksheet
Something like this:
Private Sub CommandButton1_Click()
Open A10
End Sub
Rob
Do you mean the sheet the button is on i.e. Active Sheet?
Please wrap your code in the appropriate tags as jeffreybrown had to do for your first post i.e. [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]
Thanks,
Robert
Hi Robert,
This is the assigned Macro I have on my command button.
The active sheet is Elbe
Private Sub CommandButton1_Click()
Worksheets("Elbe").[A10]
End Sub
Thanks,
Rob
Until you wrap your code in the appropriate tags I cannot help I'm afraid.
Last edited by Trebor76; 12-04-2018 at 09:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks