Excel Macro

[bigb]

Hi
I need to write a macro to copy a range of cells in a range say "A1:J2000" in a worksheet and paste it to a new file in a particular folder in my desktop.
Could you tell me what command I need to use and How I do it?
Thanks!
BigB

 

[MortenA]

Assuming EXCEL:

open the file

Start the "macro recorder"

Allways the same cells?:
Leave the "button" "relative reference" off

Relative to current positin?
set the "button" "relative reference" on

Do what you wish the macro to do and press "stop" when finished.

Open the VBA editor and edit anything you want (e.g. range or filename)

Best Regards

Morten