Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy/Paste Values & Formats from each Sheet & Book in Folder A to B.
Copy/Paste Values & Formats only (Not Formulas)
from each Worksheet and Worbook in Folder A to Folder B. For presentation/printing purpose, the Folder Source A in Path C:\My Documents, contains a Workbook named ProjList with Sheet1 Column A containing Workbooks names. The rough outline of what I am trying to achieve is as follows : For Each Workbook in ProjList Sheet1 in Folder A For Each WorkSheet WorkSheetType = Right(WorkSheet.Name,1) Select Case WorkSheetType Case "a" Delete Columns P thru AA Delete Rows 50 thru 60 Case "g" All margins to Zero PaperSize : 8.5 x 11 Fit to 1 Page High, 1 Page Wide Case Else End Select Next WorkSheet Copy/Paste Workbook Values & Formats only to Folder B (Leave Folder Source A unchanged) Next Workbook Print 5 sets of all Folder B content Thank you for your Help Wayne |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy & paste values+formats from excel to word | Excel Discussion (Misc queries) | |||
Open book, copy and paste from sheet, and then close.... | Excel Programming | |||
date values change when I copy an excel sheet to a new book | Excel Discussion (Misc queries) | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
Copy Sheet - Paste Values | Excel Programming |