Run-time error' 1004'; Method 'OpenText' of object 'Workbooks' failed

**billfinnjr** · 08-31-2018, 10:37 AM

Good morning,
I am tying to make a macro from Excel 2010 run correctly in Excel 2000. This works perfectly in Excel 2010 VBA. When I try to run it from a laptop running Excel 2000 it gives me the above error. I verified the syntax. I have verified that the file path and name are correct. I verified that the S: network drive was there and accessible. I googled the error and found a couple possibilities that don't look to be causing the error.
Any thoughts as to what is causing my problem? I would be very grateful for any input
Thanks
Bill
The macro errors out on this line;

Please Login or Register  to view this content.

Here is the macro in it's entirety;

Please Login or Register  to view this content.

**billfinnjr** · 08-31-2018, 10:49 AM

I neglected to mention that I tried commenting out the code after Workbooks.OpenText filename:= _
"H:\Estimator\QPQUPRFIL_GJH_QDFTJOBD*.txt". It solved the problem but left me with a new one, as it errored out on the line ActiveSheet.Paste Destination:=Worksheets("Item Master").Range("A1:C88888")
Thanks,
Bill

**CK76** · 08-31-2018, 10:52 AM

I believe max # of rows in Excel 2000 is 65,536. Hence the error.

**billfinnjr** · 08-31-2018, 11:44 AM

Thanks for the input CK76. I tried changing that parameter to an upper limit of 65,536 but got the same error. I tried changing the paste statement from Range "(A1:C88888)" to simply Range ("A1") and that took care of my second error and the macro ran to completion. I appreciate your taking the time to reply, you got me thinking differently and that did the trick.

thanks!
Bill

Run-time error' 1004'; Method 'OpenText' of object 'Workbooks' failed

LinkBack

Thread Tools

Rate This Thread

Display

Run-time error' 1004'; Method 'OpenText' of object 'Workbooks' failed

Re: Run-time error' 1004'; Method 'OpenText' of object 'Workbooks' failed

Re: Run-time error' 1004'; Method 'OpenText' of object 'Workbooks' failed

Re: Run-time error' 1004'; Method 'OpenText' of object 'Workbooks' failed

Thread Information

Users Browsing this Thread

Similar Threads

run time error 1004 method open of object workbooks failed

Run-time error 1004 Method Open of object Workbooks Failed

[SOLVED] run-time error '1004' method 'open' of object 'workbooks' failed

[SOLVED] Run-time error '1004': Method 'Open' of object 'Workbooks' failed

[SOLVED] Run-time error 1004 - Method 'Range' of object'_Global' failed

me too - run-time error '1004' method 'range' of object '_worksheet' failed

Method'OpenText' of object 'workbooks' failed

Bookmarks

Bookmarks

Posting Permissions