Print word doc from excel with wildcards on another partition.

**mightybhwk** · 10-11-2013, 06:47 PM

Hi all,

I'm trying to write some code so that the user can enter a material number and print out and log sheet made in Excel. (the easy part) But I also wanted to have an option to be able to print out a procedure (word doc) as well. (the hard part)

The issue I have is that the doc name may change but it will always have the material number as part of the name.

I borrowed some code from another post and came up with what's below. It works for the most part. It will find the file name with the wildcard.

The problem I'm having is that it keeps looking at the C:\ drive instead of our network drive (g:\) when it tries to open it up in word.

How can I get it to look at the full path?

Eventually, I will not have the message box or word visible. I would like it just to print the doc file in the background.

Please Login or Register  to view this content.

Thanks in advance,

Randy

**AlphaFrog** · 10-11-2013, 08:44 PM

Try something like this. Set the path in a variable and use it in both the Dir function and to open the doc file.

Please Login or Register  to view this content.

EDIT:
Note: the While-Wend will loop the Dir function until file_name is blank. So this wont open a file because of the that loop. I not sure what you want to do with the loop.

**mightybhwk** · 10-14-2013, 05:00 PM

Thanks!

Took out the while wend and the code worked perfectly! Now I just have to have it print in the background and I'm good to go.

Greatly apprectiate it and repped!