Recording Save As Macro

Sark · #1 04-24-2017, 03:34 AM

Hi All.

I regularly need to save as Web Page, Filtered in Office/Word 2003. (Too often I’ve forgotten to alter the drop down menu from the default) Just wondered if anyone knows how to create a macro that I can add to the File menu so that a Save As dialogue box opens with Web Page, Filtered set by default.

The current Save As Web Page option defaults to Single File Web Page. I can go into Tools/Save Options and permanently alter the standard Save As dialogue, but I want to leave that at the default Word Document. (I can’t reset just the Save As Web Page dialogue).

Basically I want to leave the Save As option in the File menu to its default Word Document and add a Save As Web Page option that defaults to Web Page, Filtered.

The problem I’m having that stops me doing this with a recorded macro is that as soon as I open a Save As dialogue the macro Record/Stop/Pause bar doesn’t function. Hence. I can’t stop recording until after I’ve actually recorded saving a file.

Any advice would be greatly appreciated

Mark

macropod · #2 04-24-2017, 04:22 AM

The basic code is:

Code:

Sub Demo()
With Dialogs(wdDialogFileSaveAs)
  .Format = wdFormatFilteredHTML
  .Show
End With
End Sub

Sark · #3 04-25-2017, 02:18 AM

Thanks for that. Will give it a go when I get home.

Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to save as pdf with ability to choose save as folder	rvessio	Word VBA	4	07-25-2016 12:37 PM
Macro: How to get this macro to save to a specific location	LOUF	Word VBA	1	12-07-2015 06:47 PM
recording macro in ppt 2007	rwab	PowerPoint	8	12-14-2011 07:46 AM
VBA: Recording a macro to insert a PIVOT table	e093223	Excel Programming	0	10-09-2011 01:55 AM
Recording Macro Tutorials	JesseAitchison	Word VBA	0	07-24-2011 05:36 PM