Problem with modifying Excel worksheet from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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 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!
 
Back
Top