[dba-Tech] Determine current position in Word

Bryan Carbonnell carbonnb at gmail.com
Fri Aug 26 11:27:52 CDT 2005


On 26/08/05, Bryan Carbonnell <carbonnb at gmail.com> wrote:
> On 25/08/05, Arthur Fuller <artful at rogers.com> wrote:
> > This reply tipped me off and ended up simplifying my code. Since I already
> > had the document open I did not need the additional declares, and since I
> > was already inside a With Bookmarks block, I pared your suggestion down to
> > this:
> >         .Item("AdditionalInformationTable").Range.InsertFile
> > (CurrentRTFFile)
> > And it is working! Lovely! Thanks!
> > But since I live by the theory, If it works, break it, an additional
> > question: How can I provide a folder name for the user when she saves the
> > file? The system cannot predict what the user will choose to call the file,
> > but can predict where she wants to store it.
> 
> I'm pretty sure there is, but damned if I can figure it out right now.
> I've looked at a bunch of different things, and none of them seem to
> do it.
> 
> I'll keep trying and let you know if I find anything.

DOH!!! 3 minutes later....

Try this:

With Word.Application.Dialogs(wdDialogFileSaveAs)
    .Name = "c:\FullPath\"
    ' .Show ' This will just show the dialog and you can retreive 
                ' the full path and do the save via code
    '.Execute ' This will execute the save once the user click OK
End With

You may need to trap for errors in both cases if the user clicks Cancel.

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"



More information about the dba-Tech mailing list