Excel Macro Code Help Required 1

[Sech]

Please help if you can. I have two spreadsheets and I want to copy the data from one into the other using copy and paste. I want to do this automatically from within Access.The code I have got is as follows:

Set oxlTemplateBook = oxlApp.Workbooks.Open("trending.xls&quot
Set oxlWorkbook = oxlApp.Workbooks.Open(sFilePath)
Set oxlWorksheet = oxlWorkbook.Sheets("qryTrdAvContractMileageToForeca&quot
oxlWorksheet.Columns("A:C&quot.Select
oxlApp.Selection.Copy
oxlApp.Windows("Trending.xls&quot.Activate
Set oxlTemplateSheet = oxlTemplateBook.Sheets("Contract To Forecast Data&quot
oxlTemplateSheet.Columns("A:C&quot.Select
oxlApp.Selection.Paste

However when it gets to the second columns selection line an error occurs saying "Select method of range class failed"

What am I doing wrong?

 

[celtc]

I'm not sure, but you might be better off, just selecting A1 cell on you destination sheet and letting Excel deal with the expansion.
I have found that sometimes excel does not like it when I try to help, that its better doing the minimum.