Martin

[mtownend]

Hi ,

I am tring to use access to open an excel spreadsheet and do some conditional formating but i keep getting an error the code is as follows:





.Columns("F:F").Select
.Selection.FormatConditions.Delete
.Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=or(AND(C1=44,F1>=TIMEVALUE(""09:00:00" ")),AND(C1=43,F1>=TIMEVALUE(""09:00:00"")))"
.Selection.FormatConditions(1).Interior.ColorIndex = 6

[HiTechCoach]

Is that all of the Code?

Without seeing all the code it is had to figure out what might be the issue.

Are you using Late binding?

It is also important to post the error message

What is the error message?

[mtownend]

I have figured out why my code hasnt been working i needed to add the references in the addings for microsoft excel object library thanks for your reply.


Martin

[HiTechCoach]

Martin,

Thanks for the update.

Glad you got it figure out.