[MS_AccessPros] Error controlling Excel from Access

 

I'm getting RT error 1004, Application-defined or object-defined error at

    SumRow = .Application.Selection.End(xlDown).Row + 1

Or, alternately, error 438, Object doesn't support this property or method, at

    .Application.Selection.End (xlDown)

Also, RT error 1004, Unable o set the HorizontalAlignment property of the Range class at

    .Application.Columns("G:H").Select
    .Application.Selection.HorizontalAlignment = xlCenter

All are prefaced with:

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

Can you help?

Thanks

Adam

__._,_.___

---

Posted by: runuphillracing@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 3

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___