Hello,

I need to write a Macro that will open up several workbooks (not all at
once), break all links and then save the workbook and then close it back
down.

Can anyone help me?

Thanks so much!!

Hi mydogpeanut

In this macro you can see how to open the workbooks
http://www.rondebruin.nl/copy4.htm

Then instead of the copy code you can use code from this page to break the links
http://www.rondebruin.nl/values.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mydogpeanut" <(E-Mail Removed)> wrote in message news:67827096-46DA-4CDE-BF5F-(E-Mail Removed)...
> Hello,
>
> I need to write a Macro that will open up several workbooks (not all at
> once), break all links and then save the workbook and then close it back
> down.
>
> Can anyone help me?
>
> Thanks so much!!

Thanks so much. Works great!!! I appreciate it

"Ron de Bruin" wrote:

> Hi mydogpeanut
>
> In this macro you can see how to open the workbooks
> http://www.rondebruin.nl/copy4.htm
>
> Then instead of the copy code you can use code from this page to break the links
> http://www.rondebruin.nl/values.htm
>
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "mydogpeanut" <(E-Mail Removed)> wrote in message news:67827096-46DA-4CDE-BF5F-(E-Mail Removed)...
> > Hello,
> >
> > I need to write a Macro that will open up several workbooks (not all at
> > once), break all links and then save the workbook and then close it back
> > down.
> >
> > Can anyone help me?
> >
> > Thanks so much!!
>

You are welcome

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mydogpeanut" <(E-Mail Removed)> wrote in message news:C9D6B42F-DF0E-4156-B071-(E-Mail Removed)...
> Thanks so much. Works great!!! I appreciate it
>
> "Ron de Bruin" wrote:
>
>> Hi mydogpeanut
>>
>> In this macro you can see how to open the workbooks
>> http://www.rondebruin.nl/copy4.htm
>>
>> Then instead of the copy code you can use code from this page to break the links
>> http://www.rondebruin.nl/values.htm
>>
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "mydogpeanut" <(E-Mail Removed)> wrote in message news:67827096-46DA-4CDE-BF5F-(E-Mail Removed)...
>> > Hello,
>> >
>> > I need to write a Macro that will open up several workbooks (not all at
>> > once), break all links and then save the workbook and then close it back
>> > down.
>> >
>> > Can anyone help me?
>> >
>> > Thanks so much!!
>>

On Apr 24, 5:50 am, mydogpeanut
<mydogpea...@discussions.microsoft.com> wrote:
> Hello,
>
> I need to write a Macro that will open up several workbooks (not all at
> once), break all links and then save the workbook and then close it back
> down.
>
> Can anyone help me?
>
> Thanks so much!!

I haven't ever had to do something like this before, but you can
create the directory path, loop through the Excel files within the
directory, open the workbook, break the link, and close and save
changes.

Open the Visual Basic Editor and search "BreakLink Method" (or use the
macro recorder to see how to write the syntax for breaking links), and
search for "Close Method" as well. Both of these should give you what
you are looking for.

ActiveWorkbook.BreakLink Name:=... Type:=...

Workbooks(...).Close SaveChanges:=True

Matt