"Subscript out of range" error when connecting with excel workbook

G

Guest

I get "Subscript out of range" error when connecting with excel.

The error is intermitant though. There doesn't seem to be a clear
distinction between when it occurs and when it doesn't. The code run fine
and fails with the same set of data.

The is no change in the workbook either.

I can paste the code if you would like to see it.

TIA,
Tim J
 
A

Andy Hull

Hi

Can't think of anything so if there are no ideas soon post the code.

Regards

Andy Hull
 
Top