Open MS Word Save Dialog From Excel VBA

**Skins11** · 02-01-2016, 09:47 AM

Hi All,

I'm hoping this will be just a quick query with a simple answer. I have searched elsewhere online but haven't been able to find a solution.

I have created a macro which creates a word document from a template, and populates the document with data from my excel sheet.

What I would like is that when the macro is ran, once the word document appears on the screen, the Save As Dialog box opens allowing me to save the word document. I know that it's fairly straight forward to do this within excel, i.e. if you wanted to save the excel workbook, but I wouldn't know where to start in getting it to call the MS Word Save As dialog.

Any help would be greatly appreciated.

Many thanks in advance.

**grimes0332** · 02-01-2016, 09:58 AM

Why not go record a macro in Word while you click the Word SaveAs menu, then move the genereated code into your Excel code...? There will only be minor changes but the concept is exactly the same as writing Excel VBA code.

**Skins11** · 02-01-2016, 10:12 AM

Thanks for the suggestion.

I have just tried this but it doesn't show the code for opening the save as dialog, only for how the file was saved. If I was to use this, it would save the document; however I would like it to open the save as dialog so that the user can select the name and location.

When I recorded the macro it gave me the following code:

Please Login or Register  to view this content.

Many thanks.

**grimes0332** · 02-01-2016, 10:34 AM

Exactly the same as Excel... you just need the right dialog.

This assumes you have an object named oWD which is a valid reference to an instance of Word.

Please Login or Register  to view this content.

It's only a dialog - doe snot save. You need to code for that.

**Skins11** · 02-01-2016, 11:21 AM

I'm sorry, I'm failing to get this to work. A stripped down version of my code is as below - how would I apply your code to that?

Please Login or Register  to view this content.

Thanks again.

**Skins11** · 02-01-2016, 02:27 PM

Okay, so I managed to figure it out. I'm fairly new to all of this, so I spend a lot of time fiddling and trying out before I get things to work, but the below seems to have done the trick.

Please Login or Register  to view this content.

I wasn't typing "Word" before application and so it was opening the Save As window in Excel.

Thanks Grimes for taking the time to review.

Skins

Open MS Word Save Dialog From Excel VBA

LinkBack

Thread Tools

Rate This Thread

Display

Open MS Word Save Dialog From Excel VBA

Re: Open MS Word Save Dialog From Excel VBA

Re: Open MS Word Save Dialog From Excel VBA

Re: Open MS Word Save Dialog From Excel VBA

Re: Open MS Word Save Dialog From Excel VBA

Re: Open MS Word Save Dialog From Excel VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Open Save As Dialog

Duplicate Save As Dialog - Word To PDF

IE Open-Save As-Cancel Dialog Box

Open Word SaveAs dialog from Excel VBA

Open and Save Word Documents via Excel

Microsoft Word VBA Open Dialog

[SOLVED] save file:open up a dialog

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions