App.Path in Word ?

**jandrade15** · Mar 17th, 2005, 07:43 PM

ok on that it gives me a message box telling me where the db is located. but doesnt continue the macro. ill attach the word form and the db so you can see what the default macro does..... it basically runs the mailmerge when you open the word template. like i said before its hardcoded to the c drive etc..... And i want it to find the db where ever it is located.....

What you have is on the right spot just want to automated so the box doesnt show and continues to run the macro... here is all the stuff...

Thanks a million for the help!

**RobDog888** · Mar 17th, 2005, 09:08 PM

I put the message box in so you can verify the path. Is the path correct?
I'll take a look at you doc

**jandrade15** · Mar 17th, 2005, 09:10 PM

yeah the path is correct! were right on just if the query or macro can continue were good!

**RobDog888** · Mar 17th, 2005, 09:35 PM

Just comment out the msgbox and see if that does it.

**jandrade15** · Mar 18th, 2005, 06:28 PM

When I take out the comment box it takes me to select the connection or db then the table etc.... the original macro I had took care of this it did everything automatically.......Did u get a chance to view the docs I uploaded?
Thanks again for you help!

**RobDog888** · Mar 18th, 2005, 06:40 PM

Yes, it was doing that for mee too. I have it at home so I will take another look at it tonight.

**jandrade15** · Mar 18th, 2005, 06:59 PM

Thanks again For your Help!!

Thread: App.Path in Word ?

Thread Tools

Display

Hybrid View

Re: App.Path in Word ?

Re: App.Path in Word ?

Re: App.Path in Word ?

Re: App.Path in Word ?

Re: App.Path in Word ?

Re: App.Path in Word ?

Re: App.Path in Word ?

Posting Permissions