Copy Excel sheet (values only) [Resolved]

[nightshift]

Hi - I've read through just about every forum I can find and I hope someone can help me with a problem slightly different to anything I've read.

I want to write a vb6 app. to copy a master pricing Excel Workbook (Master.xls) over to a blank Excel workbook (Pricing.xls) with just the values from each sheet in Master.xls (Don't want clients to see formulaes used in Master pricing workbook).

Number of worksheets and rows of data for each worksheet in Master.xls is variable.

I need to use non version specific coding (eg. Dim xlMaster, xlPricing as Object) so I don't have problems on client end.

Would appreciate any help to point me in the right direction.

thanks.