copying to a new workbook

[rjhe22]

hi
have this code which copies from 1 sheet to another
how can i get it to copy from 1 excel file to another or is it possible
here is my code

Please Login or Register  to view this content.

[rjhe22]

also is it possible if i have 4 sheets in 1 file to copy them over to 4 different sheets in the other file if so how can this be done

[Fotis1991]

In a simple google searching, found these(and more more others)..

http://www.excelforum.com/excel-form...-workbook.html

http://www.ozgrid.com/forum/showthread.php?t=61202

[rjhe22]

ya but i dont get what i have to do with my code to get it working

i want to keep the rest of the code the same as it works from sheet to sheet
whats the best way to do it

[rjhe22]

is this anway closer
or whats the best way to go bout it

Please Login or Register  to view this content.

i want to cpoy certain data from the spreadsheet the marco is in to\UBS_FND_OngoingCharge_Calc.xlsx