Re: Save sheet as new file w/o refs to original?
From: Ed (ed_millis_at_NO_SPAM.yahoo.com)
Date: 03/07/05
- Next message: R Avery: "RegEx to parse something like this..."
- Previous message: LFNFan: "Generalising macro 2 cycle thru checkboxes in frames/pages on User"
- In reply to: Ron de Bruin: "Re: Save *** as new file w/o refs to original?"
- Next in thread: Tom Ogilvy: "Re: Save *** as new file w/o refs to original?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 7 Mar 2005 08:46:31 -0700
Thanks, Ron. Worked great!
Ed
"Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message
news:Oz6SLZyIFHA.1360@TK2MSFTNGP10.phx.gbl...
> Hi Ed
>
> Try this
>
> Sub test()
> Active***.Copy
> With ActiveWorkbook.Sheets(1).UsedRange
> .Value = .Value
> End With
> End Sub
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Ed" <ed_millis@NO_SPAM.yahoo.com> wrote in message
news:ueXI$UyIFHA.2936@TK2MSFTNGP15.phx.gbl...
> > Is it possible to save a *** as a separate new file with a single
command
> > and carry over everything EXCEPT references to the original file? I
tried
> > it, but instead of values only I get formulas with references back to
the
> > original workbook. Or will I need to open a new book and do a series of
> > Paste Specials (values, column widths, formats, etc.)?
> >
> > Ed
> >
> >
>
>
- Next message: R Avery: "RegEx to parse something like this..."
- Previous message: LFNFan: "Generalising macro 2 cycle thru checkboxes in frames/pages on User"
- In reply to: Ron de Bruin: "Re: Save *** as new file w/o refs to original?"
- Next in thread: Tom Ogilvy: "Re: Save *** as new file w/o refs to original?"
- Messages sorted by: [ date ] [ thread ]
