Open a file with a macro

Hi,

I wonder if it's possible to create a macro that can open a file?
I need a macro-solution for this problem:
For example, if I change something in file1 and then run my macro and it will open file2 and copy some cells from file1 to file2 and then close file2 again.
Can someone help me, please?

//Vanity

Set oThis = ActiveWorkbook
Workbooks.Open Filename:="Example.xls"
oThis.Worksheets("Sheet1").Range("A1:H10").Copy ActiveSheet.Range("A1")
ActiveWorkbook.Close

--
HTH

Bob Phillips

"Vanity" <[email protected]> wrote in
message news:[email protected]...
>
> Hi,
>
> I wonder if it's possible to create a macro that can open a file?
> I need a macro-solution for this problem:
> For example, if I change something in file1 and then run my macro and
> it will open file2 and copy some cells from file1 to file2 and then
> close file2 again.
> Can someone help me, please?
>
> //Vanity
>
>
> --
> Vanity
> ------------------------------------------------------------------------
> Vanity's Profile:
http://www.excelforum.com/member.php...o&userid=24568
> View this thread: http://www.excelforum.com/showthread...hreadid=381561
>