Can I copy Sheet1 from one workbook to Sheet1 in a new workbook? Thank you.
--
Kevin C. Brown
Developer

try this
Sub copyToNewWorkbook()
Sheet1.Copy
End Sub

"KevinB" wrote:

Can I copy Sheet1 from one workbook to Sheet1 in a new workbook? Thank you.
--
Kevin C. Brown
Developer

Not sure exactly what you mean:
- you could do something like:

ActiveWorkbook.sheets("Sheet1").copy

J





On 30 May, 15:41, KevinB wrote:
Can I copy Sheet1 from one workbook to Sheet1 in a new workbook? Thank you.
--
Kevin C. Brown
Developer

I think my biggest problem is that the Workbook.SaveAs isn't working
properly. I don't think doing a copy is going to fix my problem to be
completly honest. I will, however, use your suggestions, because I'm sure I
will have to do this somewhere along the line.

Thanks again everyone.

Regards,
Kevin
--
Kevin C. Brown
Developer


"WhytheQ" wrote:

Not sure exactly what you mean:
- you could do something like:

ActiveWorkbook.sheets("Sheet1").copy

J





On 30 May, 15:41, KevinB wrote:
Can I copy Sheet1 from one workbook to Sheet1 in a new workbook? Thank you.
--
Kevin C. Brown
Developer