How to open or Print a doc or pdf file from a combobox on a userForm

[Abo Rawad]

I have a folder full of doc files. I used a userform on which i put a combobox which contains those files' names and a cmd to open the file.

I managed to copy all the files names to the WorkSheet and listed them in the combobox.

@@@ I need a VBA code to do the following :

1- looking for the file name which matches the one i choose from the combobox
2- if there is a match, show " match" on a lable.
3- when i click the "open" cmd i created on the userform, it opens the file. or even print it and close it
4- prepare for another match.

I know it a lot of work and i am not that good in VBA, but THANKS in Advance

### ###

[Paul]

Hello Abo Rawad, welcome to the forum.

I'm afraid your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

[Abo Rawad]

I am sorry , it is my bad.
I didn't read the rules.
this is the cross post link

http://www.mrexcel.com/forum/showthread.php?t=608047

sorry again

[Kyle123]

Maybe something like:

Please Login or Register  to view this content.

[Abo Rawad]

should I attach your code to the cmd ?

and there is not any mentioning to the combobox !!

[Leith Ross]

Hello Abo Rawad,

Welcome to the Forum!

It would be easier to answer your question and provide an solution if you post the workbook.

[Abo Rawad]

consider the following;

I have .doc files named file1, file2, file3, file4 up to file12 in the folder " E:\Myfolder ".

i made two comboboxes( combo1, combo2) and a commandButton (cmdOpen). i makes 3 ranges in the worksheet (4 file names in each one).
i added the items 1,2,3 to the combo1, i linked it to combo2 so that whenever i choose a number from combo1, a range will be listed in combo2 using the RowSourse property, so, eventually the file names will be listed in combo2. So far so good, Sir.

I want to add a code in the cmdOpen, so when i click it, it looks in the folder that contains the files (E:\Myfolder) for a match to the file name I chose from combo2 (e.g. file1). and if there is a match , open the file.


**** I am not using ActiveX cotrols. ****

Thank you very much for your patience, Sir.

[Kyle123]

Please post a sample workbook as Leith suggested

[Abo Rawad]

Here is what i tried :

Please Login or Register  to view this content.

this code does open the file. But i still have two problems with it :-
1- the file type is .pdf and what i need is .doc.
2- Instead of using "file1" which is the file name in the code , i want a variable that hold "combo2.value" and use it in the place of the file name. that way, when
clicking cmdOpen, it will check in (E:\folder) for a match to the filename displayed in the combo2 to , if there is a match ,it open the file .

Hope i made it clear this time

[Kyle123]

not really, please post a sample workbook

[Abo Rawad]

I attached the the Workbook.


I appreciate everything you are doing. thanks

[Abo Rawad]

Come on guys, you are the expertise. in that code i open a certain file.
Can anybody do the coding magic to solve my problem. ?

Your efforts are fully appreciated.