Copy/paste within Excel with Access code builder

[Peter Adema]

I have read a lot of posts, but did not find my problem.
From an Access(2000)query, I create an Excel file.
Some of those values must be copied/pasted into an existing Excel file/sheet.
How can I activate this open Excel file?
"Windows("Test.XLS).Activate"
"Sheets("this sheet").select"

How can I give in Access VB code a range of cells, copy them and than past
only the values into another Excel file/sheet?

Thanks for your support!

 

[Brian]

I have read a lot of posts, but did not find my problem.
From an Access(2000)query, I create an Excel file.
Some of those values must be copied/pasted into an existing Excel file/sheet.
How can I activate this open Excel file?
"Windows("Test.XLS).Activate"
"Sheets("this sheet").select"

How can I give in Access VB code a range of cells, copy them and than past
only the values into another Excel file/sheet?

Thanks for your support!

Not being an expert on Excel Automation I can't give you a detailed answer,
but articles like this should give you some clues:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210288