Reply to thread

Message: [QUOTE="GS, post: 7414650"] You don't need to copy/paste anything to get this done. Simply assign the range value to the range like so... Selction.Value = Selection.Value ...so formulas are gone and their results are now constant values. You also don't have to open any workbooks directly in Excel if you use ADODB to update the values. Simply load each sheet (table) into a recordset, edit the values, and then update the table in the file. For more info (and examples)... [URL]http://www.appspro.com/conference/DatabaseProgramming.zip[/URL] -- Garry Free usenet access at [URL]http://www.eternal-september.org[/URL] Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion [/QUOTE]