Hi al

I am automating excel 97 from Access 9

I am having problems with the range resize property. the relevant porition of my code is as follow

rngWork.selec
xlapp.selection.resize(0,Int(rsData!Rate_Input_Tim e)).Selec

I get a runtime error 1004 - application-defined or object-defined erro

Can anyone help pleas

I have tried to use the resize property in a number of solutions i have built but have never managed to get it to work through automation. I therefore have built work arounds which lead to much more code. I thought I would give you guys a try this time and try and get the answer once and for all

thanks for your hel
Michelle

Michelle,

It is probably due to not qualifying every object property that you
reference with a full application qualifier. In this case, I am referring to
rsData!Rate_Input_Time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Michelle" wrote in message
...
Hi all

I am automating excel 97 from Access 97

I am having problems with the range resize property. the relevant
porition of my code is as follows

rngWork.select
xlapp.selection.resize(0,Int(rsData!Rate_Input_Tim e)).Select

I get a runtime error 1004 - application-defined or object-defined error

Can anyone help please

I have tried to use the resize property in a number of solutions i have
built but have never managed to get it to work through automation. I
therefore have built work arounds which lead to much more code. I thought I
would give you guys a try this time and try and get the answer once and for
all.

thanks for your help
Michelle

Thanks Bob

rsData is a recordset based on a query in the database so I'm not sure this would affect the resize property would it?

regards
michelle

What is rsData!Rage_Input_Time

Is it something from access that resolves to an interger?

Anyway, you can't resize to zero. You have to have at least 1 row and 1
column.

if you want to not resize on row, then leave it blank

xlapp.selection.resize( ,Int(rsData!Rate_Input_Time)).Select

--
Regards,
Tom Ogilvy


"Michelle" wrote in message
...
Hi all

I am automating excel 97 from Access 97

I am having problems with the range resize property. the relevant
porition of my code is as follows

rngWork.select
xlapp.selection.resize(0,Int(rsData!Rate_Input_Tim e)).Select

I get a runtime error 1004 - application-defined or object-defined error

Can anyone help please

I have tried to use the resize property in a number of solutions i have
built but have never managed to get it to work through automation. I
therefore have built work arounds which lead to much more code. I thought I
would give you guys a try this time and try and get the answer once and for
all.

thanks for your help
Michelle

Thanks To

rsdata is a recordse

I didn't realise that you couldn't put 0 for the row argument - I have omitted arg as suggested and it now works

thanks for your hel
REgard
Michelle