problem with resize property

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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_Time)).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 said:
Hi all

I am automating excel 97 from Access 97

I am having problems with the range resize property. the relevant
Click to expand...
porition of my code is as follows
rngWork.select
xlapp.selection.resize(0,Int(rsData!Rate_Input_Time)).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
Click to expand...
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.
 
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 said:
Hi all

I am automating excel 97 from Access 97

I am having problems with the range resize property. the relevant
Click to expand...
porition of my code is as follows
rngWork.select
xlapp.selection.resize(0,Int(rsData!Rate_Input_Time)).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
Click to expand...
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 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
 
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
 
Back
Top