Macro to open PDF. Where to store PDF?

**emilyloz** · 06-05-2013, 08:42 AM

Okay, so I know that there is a way to open PDF's using macros, but my problem lies with where to save the macro.

I am creating an Excel document that will be shared with different users on a system like 'Drop Box.' I have directions for how to change something if they ever run into a problem. I want them to be able to access the PDF easily by clicking a button that will automatically open it for them.

If it is being saved and opened through this system, will everyone have a different address on where the PDF is saved?

I've attached the worksheet and the pdf, but I don't know how helpful they will be.

**arlu1201** · 06-06-2013, 02:54 AM

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

**emilyloz** · 06-06-2013, 08:05 AM

Hi, Sorry about that.
It never got responded to and I posted a question related to, but a little bit different. Here is the link:

http://www.excelforum.com/excel-prog...58#post3268258

The location for any file, that's saved in a drive where all company users can access it, shares the same address on all computers.