I am trying to copy a specified worksheet from one book, create a new
workbook with todays date and file name, and then drop the copied
worksheet into it.

It is testing my ability.

Can anyone help.


Thanks


--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=383762

try right mouse button
select move or copy
select new sheet

select create a copy
click ok


--
matrix5166
------------------------------------------------------------------------
matrix5166's Profile: http://www.excelforum.com/member.php...o&userid=24820
View this thread: http://www.excelforum.com/showthread...hreadid=383762

Hi Kristan,

Try:

Sub Tester02()

Dim Wb As Workbook
Dim ws As Worksheet
Dim sStr As String

Set Wb = Workbooks("MyBook1.xls")
Set ws = Worksheets("MySheet")

sStr = "MyNewBook " & Format(Date, "mm-dd-yyy")

ws.Copy
ActiveWorkbook.SaveAs sStr

End Sub



"Kstalker" wrote in
message ...

I am trying to copy a specified worksheet from one book, create a new
workbook with todays date and file name, and then drop the copied
worksheet into it.

It is testing my ability.

Can anyone help.


Thanks


--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile:
http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=383762

Norman.

Worked well thanks.

Now need to direct the newly created workbook to a specified location.
Have read alot of threads but my basics are letting me down. Or lack o
them.

Regards

Krista

--
Kstalke
-----------------------------------------------------------------------
Kstalker's Profile: http://www.excelforum.com/member.php...fo&userid=2469
View this thread: http://www.excelforum.com/showthread.php?threadid=38376

Activeworkbook.SaveAs "C:\MyExistingFolder\" & Format(Date, "mm-dd-yyy")

--
Regards,
Tom Ogilvy

"Kstalker" wrote in
message ...

Norman.

Worked well thanks.

Now need to direct the newly created workbook to a specified location.
Have read alot of threads but my basics are letting me down. Or lack of
them.

Regards

Kristan


--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile:
http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=383762

Thanks Tom and Norman

Works a treat.

Enjoying this VBA learning curve.

Regards

Kristan


--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=383762