Open file with command button... but...

[jfoerch]

Hello all,
I'm trying to figure out how to use a command button to open a file. However, I want the button to use the information in a message box as part of the file name.

Basically, my userform pulls in quote information and the quote name from a spreadsheet. I want to add a button to that user form that, when clicked will open the actual quote in whatever form it is (.doc, .pdf, .xlsx, .xlxm, etc). Not sure if that's possible... All files will be in the same location and if it simplifies things, I can make sure they're all in the .pdf form, but the main thing is that the name of the quote will be displayed in the message box and I'm not at all sure how to use that info to open the file.

I'm including a pic of the userform.

quote.jpg

Thanks!

[tigeravatar]

jfoerch,

When you say messagebox, do you mean the selected "Quote Number"?
If so, since all the items are in the same folder, you could use the following code:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[jfoerch]

AMAZED. You guys are good. Worked like a champ. Thanks so much.