Copy worksheet from one workbook to another workbook

[David Ryan]

Hi Guys hope someone can take the time to help

I have a workbook with a sheet called "hscount" I would like to copy the
values of this sheet to another workbook called "hscounttotals" with the
sheet name based on the current day, month & year, eg "01december2009" the
next month "15january2010" and so on.

I want to attached this to a button the user clicks to do the copy.

Note I only want to copy the values each time.
Regards
David

 

[David Ryan]

Hi Joel thanks for that. i think it is almost there.

when run the open file "box" opens when you select the file to open the
following error message appears.

Run time error '1004'
Application-defined or object-defined error.
When you click debug the following is highlighted in your code

NewSht.PasteSpecial _
Paste:=xlPasteValues

Hope you can assist further.

Regards David

 

[David Ryan]

Hi Joel worked a treat!! Thanks