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

[josros60]

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]

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]

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

Please Login or Register  to view this content.

Thank you

[Stiene]

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]

@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]

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

[Sbarro79]

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]

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

Please Login or Register  to view this content.

[OllieB]

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