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

 

[srisurya]

Hi
I would like to know wat kind of links are we talking about

Surya

 

[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

 

[Cobbcouk]

Thanks Don,

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

Many Thanks once again

Ga

 

[Don Guillett]

glad to help