Search results for query: *

Nothing done. It gives a compilation error. I'm dealing with it installing back Excel 2007 for the users, unfortunately. Thanks a lot!!

No. Still producing errors. I don't think it is recordset because some times the execcution passes through this point without errors. I'm suspecting it is a compatibility issue between Access 2007 and Excel 2010.

No problem Skip. Appreciate your attention. I inspected the variable during a break. It's really that value. I'm attaching the routine code because it's quite long. The error parts are highlighted in red. The value of that variable comes from an Access table put into a recordset. Any...

No tips???

Hi, SkipVought Thanks for your reply. The value is "A15:S15". It's a parametric field that I can set up before running the code. After running it's always the same value. The execution passes through this point many times but only a few give problem. I have no idea why. Basically what I'm...

I have an application created in Access 2007 that writes some Excel spreadsheets. The application worked perfectly with Excel 2007 but after switching to Excel 2010 began to display error 1004 in some specific points of the code at the time of writing in Excel. The error is always in a Range...