Solved

Save word document as docx from user form - want user to be able to browse for file location

Posted on 2016-07-14
3
63 Views
Last Modified: 2016-07-18
Hi Experts,

I'm creating a word macro enabled document (docm) that I want the user to be able to save as a word document (docx) by pressing a button (savecmd) in a userform (saveform). I've got a text box on the form (FileNametxt) where I want them to be able to write the name of the file name that the document will be saved as.

I'd also like to add a feature so they can browse for the best file location where the file will be saved.

Any advice on how I can do this?

Thanks in advance for your help
0
Comment
Question by:martywal
  • 2
3 Comments
 
LVL 49

Expert Comment

by:Rgonzo1971
ID: 41710633
Hi,

why not

Sub SaveMe()
    Set dlgSaveAs = Dialogs(wdDialogFileSaveAs)
    With dlgSaveAs
        .Name = "myDocument" ' suggested name
        .Format = wdFormatXMLDocument
        .Show
    End With
End Sub

Open in new window

0
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41710658
to force docx then use

Sub SaveMeAsDocx()

With Dialogs(wdDialogFileSaveAs)
.Format = wdFormatXMLDocument
If .Display = 0 Then Exit Sub
If .Format = wdFormatXMLDocument Then
    .Execute
Else
   MsgBox ("You are only allowed to save in docx format.  Please try again")
   Call SaveMeAsDocx
End If
End With

Open in new window

0
 

Author Closing Comment

by:martywal
ID: 41718157
Thanks Rgonzo1971, that did just as I was after. Vey helpful! Thx
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Nice table. Huge mess. Maybe this was something you created way back before you figured out tabs or a document you received from someone else. Either way, using the spacebar to separate the columns resulted in a mess. Trying to convert text to t…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now