Ill try and explain as best I can!

C

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;)
 
D

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
 
C

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
 
Top