Run-time error "1004" Application defined or object-define-error

**josros60** · 01-19-2013, 09:52 PM

I have this code which you guys helped me to do it:

Please Login or Register  to view this content.

Then I inserted a code in this workbook:

Please Login or Register  to view this content.

And when i execute the first code above I get the run-time error "1004".

thank you

**Sbarro79** · 01-19-2013, 10:14 PM

Hi josros you could continue in previous thread.
I inserted your code the same place you did and it worked fine for me.
Can you tell me in which line of code an error occurred?

**josros60** · 01-19-2013, 11:54 PM

It give the error and highlight in yellow this line of code:

Please Login or Register  to view this content.

Thank you

**Stiene** · 01-21-2013, 07:19 AM

I am still learning a lot. Most of the problems I occur have been solved already in the past and allows me to learn fast.

**OllieB** · 01-21-2013, 08:48 AM

@josros60, are you by any chance opening a 2003 workbook (i.e. ReportProxyServlet.xls) from within a 2007/2010 workbookbook (thisworkbook)? If the answer is YES, then change your line of code into

Please Login or Register  to view this content.

**josros6074** · 01-21-2013, 12:44 PM

yes, i print a report from a website "ReportProxyServlet.xls" and it's save in excel.

**Sbarro79** · 01-21-2013, 01:04 PM

Hey josros6074 (aka josros60 - is it the same person?) did you save WRITEOFF file as Excel 2007 file (xlsm)? If yes, that may be the cause why you get an error

**josros6074** · 01-21-2013, 01:09 PM

thank you worked just changing the lie of code to the one you suggest:

Please Login or Register  to view this content.

**OllieB** · 01-21-2013, 01:14 PM

Great. I had posted this recently in the tips & tricks section. The underlying cause is that without the Sh2. the Rows.Count parameter returns a value that is too high for the 2003 workbook, but by qualifying the parameter to the 2003 worksheet it only returns 65k which is valid