Macro: How to open not-excel-files by using excelvalue onWorkbooks.Open Filename oa?

S

Snoopy

Hey Guys
I' v made a list in Excel to show all files in a folder.
Now I want to open singel file; choosing from this list.
The file in folder could be either, Excel, Word, PDF or common picture-
format.

In case of not-macro-based actions I would use hyperlinks to open the
files on regular basis, but I whant to make a "pick and choose"-
function by using list/combo-box or something.
I cell F2 I have constrructed full path/namevalue in order to open the
chosen file.

Example
File1.xls - make cell F2 value: Y:\MyFolder\File1.xls - opens in
Excel
File2.pdf - make cell F2 value: Y:\MyFolder\File2.pdf - opens in
Acrobat Reader
File3.doc - make cell F2 value: Y:\MyFolder\File1.doc - opens in in
Word
etc

I will certainly appreciate your kindly help on this
Regards Snoopy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Get sheets name without file open 7
using VBA to make another open mde file the active window 3
How to open 2 excel instances by using XP schedule tasks? 2
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Excel Macro to Open and Print Multiple PDF Files 6
Macro: Hyperlink shown as ...."OPEN file" 2
Cannot open PDF file that is attached to digitally signed xls file asan object - Excel 2007 0
Variable available to all open xl files 1

Top