Open .ppt file from excel command button

[DrEvilAces]

Hi

I have created a large process map workbook in excel that links to various areas within the document using command buttons.

However, one of the things I need users to be able to see s in a PowerPoint presentation.

All I need to do is create a command button that links to, and opens this .ppt file.

The .xsl and .ppt files will be distributed in a folder to other members of the team so I need the link to not be specific to my computer. Is it possible to avoid using the full path and just use a short path such as .../desktop/tools/process.xls so that as long as they store the folder on their own desktop the link works?

I'm struggling to work this one out so would appreciate your help.

Thanks in advance

[DrEvilAces]

Sorry to bump but I could really use some help on this, please?

[Greg M]

Hi there,

Try the following:

Please Login or Register  to view this content.

The PowerPoint presentation should be stored in the same folder as the Excel workbook.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[DrEvilAces]

Hi Greg

Thanks for the code, I'm not sure where I shuld be putting it though!

Should it go in the

Please Login or Register  to view this content.

of the button code or should it sit in a seperate module?

If it goes in a seperate module how does that then link to the _Click() Sub of the button.

Sorry if these are obvious questions but I'm a total beginner a VB. I know how to record macros and copy and paste them into Private Sub's but that about it!

Many Thanls

[Greg M]

Hi again,

Sorry for the delay in getting back to you.

I'm assuming you want to put a button on the worksheet itself, which is probably all that you need. Let me know if you want to create a userform, but in that case you'll probably need a button on the worksheet anyway (in order to display the userform).

The code should be placed in a standard VBA code module.

First, delete the word "Private" from the following code:

Please Login or Register  to view this content.

To create a button on your worksheet, use View >> Toolbars >> Forms, to display the Forms toolbar. This toolbar will allow you to create a button anywhere you like on your worksheet. When you do this, the "Assign Macro" dialog box will open, and the macroname "OpenPowerPointPresentation" will be visible. Select it, and then click on "OK". The macro will now be executed whenever the button is pressed.

Finally, re-insert the word "Private" into the code shown above - it's not absolutely essential to do this, but it's probably good practice.

Hope this helps - as before, please let me know how you get on.

Regards,

Greg M

[DrEvilAces]

Hi Greg

Through experimenting with your original code and a bit more leg work I came up with this:

Please Login or Register  to view this content.

And it seems to work perfectly, main thing is it works not sure how or why! But it works

Thanks for all your help Greg

Cheers

[Greg M]

Hi again,

Many thanks for your feedback - glad I was able to help.

Regards,

Greg M