How to open or Print a doc or pdf file from a combobox on a userForm
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
### ###
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
### ###