copy/paste special, values and colours only excel 97 
Author Message
 copy/paste special, values and colours only excel 97

Hello All
I have a spreadsheet that is full of formulas and conditional formatting.
Periodically a macro performs a saveas of this spreadsheet for archive
purposes. The saved file is then also full of formulas and conditional
formatting. I would like to just save the data and the colours. I have
played with copy/pastespecial and I noticed that if I have 2 separate Excel
applications running I can copy/pastespecial a Microsoft Excel Worksheet
Object between the 2 and get what I want. However when I try this between 2
different workbooks within the same Excel application the copy/pastespecial
doesn't give me the Microsoft Excel Worksheet Object option. What's the
deal? Am I going about this the right way? I can handle the code to open a
new workbook within a single Excel application but I don't know how to open
another instance of Excel. Any guidance in a logical way to go about this
would be much appreciated. Many thanks for your time,
Paul


Sun, 30 Jan 2005 10:31:09 GMT  
 copy/paste special, values and colours only excel 97

Quote:

> I would like to just save the data and the colours.
>...
> I have
> played with copy/pastespecial and I noticed that if I have 2 separate Excel
> applications running I can copy/pastespecial a Microsoft Excel Worksheet
> Object between the 2 and get what I want.

But that object will have the formulas and formats as before.

To keep the colours you will need to keep the formatting of the cells.

To lose the formulas,
Edit / Copy
FIle / New
Edit / Paste Special / Values
Edit / Paste Special / Formats

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup



Fri, 04 Feb 2005 16:19:43 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Copy and paste special values without switching sheets

2. vba-select multiple disconnected ranges - to copy paste special values in place

3. Can't Sort after Formula then Copy/Paste Special/Value

4. Copy & Paste-Special-Value

5. Can cut or copy Can Not select paste or paste special

6. Excel 97 chart source data and paste special

7. Excel 97 Copying Range and Paste into FrontPage 97

8. Update Excel Chart on Access Form Created from Paste Special (Paste as a Link)

9. Update Excel Chart on Access Form Created from Paste Special (Paste as a Link)

10. Using copy past Special Only Value when user put value in other cell


 
Powered by phpBB® Forum Software © phpBB Group