Write data from one spreadhseet to another

[mpadgett]

I'm going to develop some code to write some data from a currently opened Excel spreadsheet to another. Is the best way to accomplish this to do a Workbooks.Open and Workbooks.Close or is there a way to write to the file with out opening it?

Thank - Mike P.

 

[SkipVought]

Hi,

Depending on the data source, if you have TABLES in your workbook, you can use MS Query.

Using MS Query to get data from Excel faq68-5829

Skip,

_[red][/red]