#1
|
|||
|
|||
Recording Save As Macro
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 |
#2
|
||||
|
||||
The basic code is:
Code:
Sub Demo() With Dialogs(wdDialogFileSaveAs) .Format = wdFormatFilteredHTML .Show End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks for that. Will give it a go when I get home.
Mark |
Thread Tools | |
Display Modes | |
|
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 |