[MS_AccessPros] Re: Error controlling Excel from Access

 

Graham,

Again, thanks so much for the detail. I have most of this working (this is for several applications). However, I'm still getting RT error 438, "Object doesn't support this property or method" at the FreezePanes line:

Set xlApp = CreateObject("Excel.Application")
Set xlSheet = xlApp.Workbooks.Open(stFileName).Sheets(1)

With xlSheet

    .Range("C1").Select
    .ActiveWindow.FreezePanes = True

End With

Adam

__._,_.___

---

Posted by: runuphillracing@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (20)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___