| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using programming to copy worksheets data only
Hi,
How can i use programming to copy all the worksheets from an excel file to another excel file as data only (i do not want the formulas to be copied as formulas but as data) ? i can see there's copydatafromrecordset but it's not suitable and also there the copy method from worksheet (this will copy the formula) kindly advice tks & rdgs |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Threaded Mode
