A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Macro: Close Doc, Open the "Open File" Box



 
 
Thread Tools Display Modes
  #1  
Old June 24th, 2004, 01:21 PM
Lorna
external usenet poster
 
Posts: n/a
Default Macro: Close Doc, Open the "Open File" Box

Does anyone know how to write a macro that will bring me automatically to the "open file" dialog screen automatically when I close a word document? ie... now when a document is closed, Word goes to the blank word page, and I have to click the little "open file" icon to get the dialog box. Well, I'm always opening and closing documents, so I want to go directly to a list of files to click and open. I tried a maco that said Ctrl W (to close doc), Enter (to say yes to save) then Ctrl O to get the list of files to open in my folder, but the macro wasn't allowed.

Can anyone help? Thanks.

THANK YOU!!!



  #2  
Old June 24th, 2004, 02:36 PM
Graham Mayor
external usenet poster
 
Posts: n/a
Default Macro: Close Doc, Open the "Open File" Box

Sub AutoClose()
Dialogs(wdDialogFileOpen).Show
End Sub

See http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Lorna wrote:
Does anyone know how to write a macro that will bring me
automatically to the "open file" dialog screen automatically when I
close a word document? ie... now when a document is closed, Word goes
to the blank word page, and I have to click the little "open file"
icon to get the dialog box. Well, I'm always opening and closing
documents, so I want to go directly to a list of files to click and
open. I tried a maco that said Ctrl W (to close doc), Enter (to say
yes to save) then Ctrl O to get the list of files to open in my
folder, but the macro wasn't allowed.

Can anyone help? Thanks.

THANK YOU!!!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
GPO Office 2003 Tony Setup, Installing & Configuration 1 May 12th, 2004 10:42 AM
Macro command to open a file sowetoddid Worksheet Functions 3 April 24th, 2004 01:16 AM
Cannot open large excel file Niall Caslin Worksheet Functions 3 October 29th, 2003 05:24 PM
excel; File Open or click on open folder [email protected] Setting up and Configuration 0 October 29th, 2003 05:15 PM
Macro Function Help File Trevor Hedges Worksheet Functions 0 October 16th, 2003 03:14 PM


All times are GMT +1. The time now is 04:41 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.