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 <Kevin.Br...@DarbyDentalSupply.com> 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 <Kevin.Br...@DarbyDentalSupply.com> wrote:
> > Can I copy Sheet1 from one workbook to Sheet1 in a new workbook? Thank you.
> > --
> > Kevin C. Brown
> > Developer
>
>
>