Excel Copy Workbook Converting Formula to Values

[StellaIndigo]

Hi

I have a problem where my admin staff have a large number of Excel workbooks that have links to external data sources. They need to send the workbooks to mobile users so the formula and external links need to be converted to values so they can read.

My thought is to copy the workbook and then Copy - Paste Special - values and formats all the data in every sheet over the top of its self. Then send the copy. (copy and paste set up as a macro).

Anyone got any better ideas or am I missing something with an Excel feature?

Regards

Stella

Regards
Stella

There are 10 types of people in the world. Those that understand binary and those that don't.

 

[SkipVought]

Hi,

Sounds good

    Dim ws As Worksheet
    For Each ws In Worksheets
      With ws
        .Cells.Copy
        .[A1].PasteSpecial xlValues
      End With
    Next

Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}