Save and Close Excel with Macros

[Delano29]

Hi All,

Is there a way to save and close Excel files using a macro? I have several linked files located on a network. The process of updating the links takes quite a long time and would like to automate as much as possible. I have used the 'Start' command to open the workbooks but stuck on saving and closing.

Thanks.

 

[AnotherHiggins]

Yes, this can certainly be done.

But please repost your Macro-specific question in forum707.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Delano29]

Thanks. Will do.