New object/automation error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephen - 26 Jan 2006 00:02 GMT

I need to create a new sheet in my macro. So far the code I've been using
looks something like this:

Dim sheet7 as worksheet
sheet7 = new worksheet

But I keep getting error saying that the object doesn't support automation.
I'm still a new programmer and I'm not sure what automation is. I can't seem
to find any documentation to tell me what I'm doing wrong.

Reply to this Message

Norman Jones - 26 Jan 2006 00:09 GMT

Hi Stephen,

Try:

Dim SH As Worksheet

Set SH = Worksheets.Add

---
Regards,
Norman

>I need to create a new sheet in my macro. So far the code I've been using
> looks something like this:
[quoted text clipped - 7 lines]
> seem
> to find any documentation to tell me what I'm doing wrong.

Reply to this Message

Jim Thomlinson - 26 Jan 2006 00:11 GMT

When objects are created or referenced you need the set statement.

Dim wksNew As Worksheet

Set wksNew = Worksheets.Add

Don't use Sheet7 as your variable as Excel uses Sheet1, Sheet2, ... as it's
default names when new sheets are created and you could run into some
difficulties.

Signature

HTH...

Jim Thomlinson

> I need to create a new sheet in my macro. So far the code I've been using
> looks something like this:
[quoted text clipped - 5 lines]
> I'm still a new programmer and I'm not sure what automation is. I can't seem
> to find any documentation to tell me what I'm doing wrong.

Reply to this Message