ACCESS FEED: Re: [MS_AccessPros] Error controlling Excel from Access

Rabu, 28 Januari 2015

Adam-

I would think that the Selection and Columns properties are members of a worksheet, not Application.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

(Paris, France)

On Jan 28, 2015, at 6:53 PM, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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: John Viescas <johnv@msn.com>

Reply via web post

•

•

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

__,_._,___

ACCESS FEED