Ill try and explain as best I can!

[Cobbcouk]

Hi,
This is a bit of a weird one so please bear with me!!!!!!!!!!

I want to create an excel workbook that is full of references from other workbooks. The data will obviously change as it is updated. Is there a way to make the workbook where all the data is collated to stop updating when you save it? Basically I want to 'save as' the workbook under a different name and take a snapshot of the data in the other wookbooks!

I hope I have explained myself well enough.

I just need to know if its possible and if so how

hopefully

Gaz

[Don Guillett]

I assume that your links are formulae. So, change all to values (with a
macro) and then save as a different name to get your "snapshot"

--
Don Guillett
SalesAid Software
[email protected]
"Cobbcouk" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
> This is a bit of a weird one so please bear with me!!!!!!!!!!
>
> I want to create an excel workbook that is full of references from
> other workbooks. The data will obviously change as it is updated. Is
> there a way to make the workbook where all the data is collated to stop
> updating when you save it? Basically I want to 'save as' the workbook
> under a different name and take a snapshot of the data in the other
> wookbooks!
>
> I hope I have explained myself well enough.
>
> I just need to know if its possible and if so how
>
> hopefully
>
> Gaz
>
>
> --
> Cobbcouk
> ------------------------------------------------------------------------
> Cobbcouk's Profile:
> http://www.excelforum.com/member.php...o&userid=32143
> View this thread: http://www.excelforum.com/showthread...hreadid=526341
>

[Cobbcouk]

Thx,
I really should learn more about macros!!!!!!!!!



Ill give it a go

[Don Guillett]

the macro recorder is your friend
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 3/26/2006 by Don Guillett
'

'
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:=
_
xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
ActiveWorkbook.SaveAs Filename:="C:\Personal\snapshow.xls", FileFormat:=
_
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub

--
Don Guillett
SalesAid Software
[email protected]
"Cobbcouk" <[email protected]> wrote in
message news:[email protected]...
>
> Thx,
> I really should learn more about macros!!!!!!!!!
>
>
>
> Ill give it a go
>
>
> --
> Cobbcouk
> ------------------------------------------------------------------------
> Cobbcouk's Profile:
> http://www.excelforum.com/member.php...o&userid=32143
> View this thread: http://www.excelforum.com/showthread...hreadid=526341
>

[Cobbcouk]

Thanks Don,

I've started playing with the macro recorder and i don't know how I ever excelled without it.

Many Thanks once again

Gaz

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"Cobbcouk" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks Don,
>
> I've started playing with the macro recorder and i don't know how I
> ever excelled without it.
>
> Many Thanks once again
>
> Gaz
>
>
> --
> Cobbcouk
> ------------------------------------------------------------------------
> Cobbcouk's Profile:
> http://www.excelforum.com/member.php...o&userid=32143
> View this thread: http://www.excelforum.com/showthread...hreadid=526341
>