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