Export error "Subscript out of range"

[DevKumar]

Hello

I am trying to export a report to Excel but get the "Subscript out of range" error. I haven't been able to find a reason or solution for this error.There are similar posts in this forum, but none have any replies. Can anyone help, please?

I would appreciate it very much.

 

[DevKumar]

As there isn't much information available, I thought I would post what I have found out so far...

This is, apparantly, an acknowledged Microsoft Bug in Access, that existed until SR1. I believe it has been subsequently fixed but cannot confirm this as our software is restricted and we are running Access 2000 SR1.

 

[Kodo]

subscript out of range is an array error message. It means the counter has gone beyond the bounds of the array.

Since you can't update your software, try putting
On Error Resume Next
before your export and see what happens.

 

[DevKumar]

Kodo,

Unfortunately, I am using the built in "Analyze it with MS Excel" button, so I can't add the error trap. If you have an alternative method for exporting to excel, I would appreciate it.

Thanks for your help.

Dev

 

[dangermouse]

I had a similiar problem and sent the query to excel in portions to limits the maximum output and stop the crashes...

have you tried this?