Problem with modifying Excel worksheet from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allen_N - 08 Mar 2007 01:29 GMT

I have a rooutine that exports reports to Excel and them tidies them up (via
ActiveX). It works well until the line:

.Selection.Delete Shift:=-4159 ': -4159 = xlToLeft

when I get the error:
"Object doesn't support this property or method".

Is this because Access doesn't recognise the "Shift:=" parameter? If so,
what is the syntax for passing parameters via ActiveX?

Thanks!

Reply to this Message

Allen_N - 08 Mar 2007 02:10 GMT

Oops: my problem turns out to be deeper than I thought. All of the Excel
methods produce this error. I'll have to dig deeper before rephrasing the
question.

> I have a rooutine that exports reports to Excel and them tidies them up (via
> ActiveX). It works well until the line:
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message

Allen_N - 08 Mar 2007 02:50 GMT

I fixed it! It seems the .Selection property makes Access choke. If I use:

object.Delete (-4159)

instead of:

object.Select
Selection.Delete (-4159)

I have no problems.

Cheers!

> I have a rooutine that exports reports to Excel and them tidies them up (via
> ActiveX). It works well until the line:
[quoted text clipped - 8 lines]
>
> Thanks!

Reply to this Message